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: Sybrand Bakker <gooiditweg_at_sybrandb.verwijderdit.demon.nl>
Date: Tue, 17 Aug 2004 20:08:41 +0200
Message-ID: <7ci4i09ppm06md70esbvnej3li79aqbtf0@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 Bakker, Senior Oracle DBA


Received on Tue Aug 17 2004 - 13:08:41 CDT












Original text of this message













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