SQL & PL/SQL

Hi,

I have a procedure that is called by .NET. SYS Ref cursors are being return to .NET from the procedure. I want to know HOW I can TEST the procedure by calling it from SQL. I'm calling and passing the same IN parameters as .NET would, but having errors. I think thats due to the SYSREF Cursors. Here's the SQL Command that calls it:

begin

template_tst_pkg.getTemplate (413, 'KF-TEST-MASTER', 1, -1, 1);

end;

And here's the spec for the proc:

PROCEDURE getTemplate (
    p_Template_Code            IN  Template.TEMPLATE_CODE%TYPE,
    p_Template_Version         IN  Template.VERSION_NUMBER%TYPE,
    p_Master_Template_Version  IN  INTEGER,
    p_Include_Attachments      IN  INTEGER,
    RESULT_SET_TEMPLATE_LIST   OUT SYS_REFCURSOR,
    RESULT_SET_COMPONENT_LIST  OUT SYS_REFCURSOR,
    ERROR_CODE_LIST            OUT SYS_REFCURSOR) IS

Please Help !

Thanks in advance,

Marc.