Executing Package from SQL PLUS

[IT4EVR]

I seem to be getting an error whenever I try to run a package stored procedure that returns a REF CURSOR.

For example:

 TYPE T_CURSOR IS REF CURSOR; 
 PROCEDURE proc_sel_URLLINK(LINKCURSOR OUT NOCOPY T_CURSOR);

I then try to call it in SQL PLUS as

SQL> BEGIN
  2  PKG_URLLINKS.proc_sel_URLLINK;
  3  END;
  4  /
PKG_URLLINKS.proc_sel_URLLINK;

PLS-00306: wrong number or types of arguments in call to proc_sel_URLLINK

There is probably something I am forgetting here.

 

[IT4EVR]

Why would I need to supply an argument if I have an OUT Parameter?

 

[LKBrwnDBA]

If you do not supply an argument, where is the procedure supposed to return the value?


----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[IT4EVR]

Thanks for the clarification. I guess I looked like an idiot on that one.