PLSQLDeveloper has that ability as well.
--
Terry Dykstra
Canadian Forest Oil Ltd.
"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
news:4f75121uehthoc9lul5jn7emedop4mtrhh_at_4ax.com...
> On 10 Mar 2006 07:17:15 -0800, seanbrasher_at_gmail.com wrote:
>
> >I call this package and function from .NET and it works fine, returning
> >the two result sets, but I would like to be able to test this in TOAD
> >with something like this:
> >
> >DECLARE
> >test1 SYS_REFCURSOR;
> >test2 SYS_REFCURSOR;
> >
> >BEGIN
> >
> >exec MY_PKG.SAMPLE_FUNC(test1, test2, 'Smith');
> >
> >print test1;
> >
> >print test2;
> >
> >END;
> >
> >Obviously this syntax does not work. What do I need to do to make it
> >work?
>
> Toad has a refcursor tab in the output window, at least in 8.5.x and
> higher.
>
> --
> Sybrand Bakker, Senior Oracle DBA
Received on Mon Mar 13 2006 - 09:28:50 CST
