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

There are a number of solutions provided in this newgroups... just do a search under "refcursor begin select print".

The following example from Mark C Stock... posted last week ! (just when I needed to figure out how to do it myself :)

var rc refcursor
SQL> begin
  2 open :rc for 'select * from all_users';   3 end;
  4 /

 print rc Received on Fri Apr 07 2006 - 14:16:04 CDT