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
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