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

dean wrote:
> I don't know anything about the procedure, other than that it returns a
> dataset. What I am asking is if its possible to use SQL+ to examine the
> output of the procedure (i.e. its dataset)? Is it something of the
> flavor of
>
> set serveroutput on
>
> exec MyProc(1)
>
> ?

It is. And you had gone to Morgan's Library at www.psoug.org. Looked up REF CURSOR you would have seen a demo of how to do it.

But before we assume it is a REF CURSOR do this:

SQL> desc <procedure_name>

Post the output.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)