Re: Can anyone shed any light on how to run a package in TOAD and return a recordset?

Originally posted by Rubber Duck
> Can anyone shed any light on how to run a package in TOAD and return a
> recordset?
>
> I've heard its not for the faint of heart, can anyone point me to any
> examples or suggest a better alternative?
>
>
>
> Thanks
>
> PT

I am guessing that your package returns a ref cursor. If that is the case then you will have to wrap the package call in a anoynmous block and then do the fetches and display using dbms_output.

Oh, and remember to close the cursor.

• rajXesh

--
All you need in this life is ignorance and confidence, and then success is sure. -- Mark Twain (1835 - 1910)


Posted via http://dbforums.com