I have a stored proc in 2 environments one running oracle 10g and the other running oracle 22.214.171.124.2. I am using Toad for development and testing the packages/procedures.
In the procedure I am returning a ref cursor to the calling program which is a java program.
I want to test the output of the procedure and in Toad I can click on the ''thunderbolt' icon and it opens a window to enter input parameters and in the options tab I can select to display the ref cursor output in a grid.
This works in Oracle 10g and I get the ref cursor output in a grid. But in Oracle 126.96.36.199 I get an error which says
ORA-24338: statement handle not executed
what does this mean?? and do i need to change the code to see the output?