Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to fire a stored proc from a query window
Sybrand Bakker <gooiditweg_at_sybrandb.verwijderdit.demon.nl> wrote in message news:<7ci4i09ppm06md70esbvnej3li79aqbtf0_at_4ax.com>...
> On 17 Aug 2004 09:22:44 -0700, lduhl_at_corp.realcomp.com (Lee) wrote:
>
> >variable dummy_var Omwb_emulation.globalPkg.RCT1
> >exec sa.usp_Lees_Test_Sp(strAgentCode =>'297', :dummy_var);
> >
> >I'm assuming my "RCT1" cursor is returned populated with the 50+
> >records that were found, but how do I get those results displayed.
>
> print <ref cursor var>
>
> as documented!
Sybrand
Thanks, but isn't "Print" specific to SQL*Plus? We dont use SQL*Plus, we use a 3rd party package (DBArtian).
How would the results be displayed using PL/SQL Syntax?
Thanks
Lee
Received on Wed Aug 18 2004 - 08:02:26 CDT