Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Returning cursor from PL/SQL function using DBMS
Thank you Daniel! That worked.
"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message
news:1069360380.416572_at_yasure...
> Boffo Jinko wrote:
>
>> <my code snipped>
>
> Go to http://tahiti.oracle.com and look up the OPEN FOR syntax for
> native dynamic SQL as in the following example:
>
> CREATE OR REPLACE PROCEDURE child (
> p_NumRecs IN PLS_INTEGER,
> p_return_cur OUT SYS_REFCURSOR)
> IS
>
> BEGIN
> OPEN p_return_cur FOR
> 'SELECT * FROM all_tables WHERE rownum <= ' || p_NumRecs ;
>
> END child;
> /
>
> --
> 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)
>
Received on Fri Nov 21 2003 - 09:50:26 CST