Hi,

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"
IS
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);
end
;


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?

Thanks,
Florian