Re: cursor

Hi Kiam.
You can view the result from out parameter (ref cursor) from PL/SQL procedure using
SQL*PLUS for instance:
1) create variable of type "refcorsor";

      var abc refcursor;
2) assign this variable to respective output parameter;

    begin <name procedure>(....,:abc); end; 3) print the value of this variable on the screen;

    print abc;

For function the step 2 a little bit changes; :abc=<name function>(<list of parameters>);

Hope this help.
Good luck.

Michael Malyk
Oracle Programmer

"Kiam Lun (IT-HO)" wrote:

> Dear All
>
> I have out parameters as ref cursor type in a procedure.
> And I want see the result from that parameters.
> How can I do that from oracle not from client application?
>
> Thanks
>
> Alun
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Kiam Lun (IT-HO)
> INET: Kiamlun_at_japfacomfeed.co.id
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Wed Dec 13 2000 - 09:37:59 CST