Re: How do I view SYS_REFCURSOR output parameters in TOAD?

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