'ORA-06550: linha 1, column 7: PLS-00201: the identifier 'GETTIMEZONE' must be declared
I created a procedure in ORACLE
create or replace PROCEDURE GETTIMEZONE
(timeZone IN VARCHAR2,
cur IN OUT SYS_REFCURSOR)
is
BEGIN
open cur FOR SELECT MLT.description
FROM Master_ISO_TimeZone MI
INNER JOIN Master_Language_Translation MLT
ON MLT.Language_Translation_Id =
MI.Language_Translation_Id
WHERE MI.time_zone_id = timeZone;
END GETTIMEZONE;
and i´m calling in my .NET api
OracleParameter[] param = new OracleParameter[2];
param[0] = new OracleParameter("timeZone", OracleDbType.Varchar2, timeZoneFromUi, ParameterDirection.Input);
param[1] = new OracleParameter("cur", OracleDbType.RefCursor, ParameterDirection.Output);
Command.CommandType = CommandType.StoredProcedure;
Command.CommandText = SP_Constants.GETTIMEZONE;
Command.Parameters.AddRange(param);
Command.ExecuteNonQuery();
but I get this error:
ORA-06550: linha 1, column 7:
PLS-00201: the identifier 'GETTIMEZONE' must be declared
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
