Toad World® Forums

viewinig sys_refcursor output from an Oracle package


#1

package.procedure(

‘SITE’

,‘MISSION’

,‘START’

,‘END’

,:cv

END;

I just upgraded from Toad 9.7 to Toad 10.0.

The following test code works fine in Toad 9.7 - when I press F9 to execute, I’m prompted for a data type for the :cv variable (sys_refcursor), I choose cursor and happily get all the rows returned from the package in the data grid.

With Toad 10, I don’t have the option of choosing a cursor for :cv, only the common charactor, number and date datatypes.

Any suggestions on how I can see the results of my package using Toad 10?

Thanks, Bruce

BEGIN );