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

Home -> Community -> Usenet -> c.d.o.misc -> Re: SP return Cursor

Re: SP return Cursor

From: Ben Graham <bengraham1977_at_gmail.com>
Date: 2 Dec 2005 02:45:16 -0800
Message-ID: <1133520316.831710.269650@g14g2000cwa.googlegroups.com> 





You can use the SQL*Plus print command and a refcursor variable:



SQL> var x refcursor


SQL> exec SP_WEB_MES( P_I_SCALE => 'H', P_V_MULTISOURCE => 'NORMAL',
P_V_TYPE => 'NORMAL', P_V_STATUS => 1, CRS_DATA => :x);
PL/SQL procedure successfully completed.
SQL> print x


..... rows are printed and can be formatted using column command

..... use Ctrl+C to stop output

Received on Fri Dec 02 2005 - 04:45:16 CST












Original text of this message













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