I have create a package that includes a stored procedure that take some IN parameters and returns a cursor.
This is the package header:
CREATE OR REPLACE PACKAGE "APPLICATION_PCKG"
TYPE curApplicationSelect is ref cursor;
procedure STAPPLICATIONSELECT (pID IN NUMBER default null,
pCode IN VARCHAR2 default null,
pName IN VARCHAR2 default null,
pDescription IN VARCHAR2 default null,
pLanguage IN VARCHAR2 default null,
p_rc out curApplicationSelect);
How should I execute this stored procedure from PL/SQL? It seems that there is a problem because of the last parameter.
I have done a small vb.net program that calls this stored procedure but there I knew how to define the output parameter.
Can you please write the synthas I should use to call this st proc from PL/SQL?