Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to fire a stored proc from a query window

Re: How to fire a stored proc from a query window

From: Lee <lduhl_at_corp.realcomp.com>
Date: 18 Aug 2004 06:02:26 -0700
Message-ID: <719532c5.0408180502.3fac9401@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US