'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