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: Stored Proc returns dataset - how to see results in SQL+?

Re: Stored Proc returns dataset - how to see results in SQL+?

From: DA Morgan <damorgan_at_psoug.org>
Date: Sat, 08 Apr 2006 10:09:52 -0700
Message-ID: <1144516187.54159@yasure.drizzle.com>


dean wrote:
> If you have a stored procedure in Oracle 9.2 and it returns a result
> set, can you see what that result set looks like in SQL+?
>
> Something like:
>
> select * from (ExecProc(MY_PROC_NAME(1,2,3,4))) ?
>
> Thanks for any tips!
>
> Dean

Go to Morgan's Library at www.psoug.org. Look at the REF CURSOR demos.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Sat Apr 08 2006 - 12:09:52 CDT

Original text of this message

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