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: 23 Aug 2004 05:11:06 -0700
Message-ID: <719532c5.0408230411.5a7e1b24@posting.google.com>


Frank

Thanks for the info, I'll give it a shot!

Frank van Bortel <fvanbortel_at_netscape.net> wrote in message news:<cg745o$mee$1_at_news3.tilbu1.nb.home.nl>...
> Lee wrote:
> > Frank
> >
> > Thanks for the info. The VarChar thing was a typo in the sample and
> > the "Omwb" was copied from another sp that did come from the
> > Workbench. We have since found out the "Non Workbench" method of
> > using and refering to them in the proc.
> >
> > The whole problem from the original post was how to call the proc and
> > get the returned Ref Cursor back and display the results.
> >
> > Actually at this point we still have not figured it out. Doing this
> > same thing is a MS SQL world is very simple becuase the result sets
> > (or record sets) are returned by default.
> >
> > Thanks
> > Lee
> >
>
> Don't know about DBArtisan, sorry. In an SQL session it would be as
> simple as:
> SQL> var r refcursor
> SQL> set autoprint on
> SQL> begin SA.USP_LEES_TEST_SP (strAgentCode => 'H10', RC1 => :r); end;
> 2 /
Received on Mon Aug 23 2004 - 07:11:06 CDT

Original text of this message

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