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

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

From: dean <deanbrown3d_at_yahoo.com>
Date: 7 Apr 2006 11:50:41 -0700
Message-ID: <1144435841.546298.116320@j33g2000cwa.googlegroups.com>


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 Received on Fri Apr 07 2006 - 13:50:41 CDT

Original text of this message

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