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 );