Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Stored Proc returns dataset - how to see results in SQL+?
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
![]() |
![]() |