Re: REF CURSORS as procedure output parameters

Eric wrote:

> I'm new in the oracle world and I tried to call the procedure and the
> function in SQL Worksheet in the following way but I get an error that
> tells me that the cursor variable is of the wrong type.
> Could someone give me the right way to execute the procedure and get
> the out parameter, execute the function and get the result.
> Did I a mistake in the cursor definition that get the result. Or do i
> have only the solution to declare a cursor variable in the package.
> Thanks for any helpful response.
>
> Eric

The web page, below, isn't completed ... but it has a working demo you can use:

http://www.psoug.org/reference/ref_cursors.html

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)