Link to home
Start Free TrialLog in
Avatar of chickanna
chickannaFlag for Afghanistan

asked on

error running a stored proc in toad -- oracle ver 9.2

Hello Experts..  
  I have a stored proc in 2 environments one running oracle 10g and the other running oracle 9.2.0.6.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 9.2.0.6 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?
Avatar of ajexpert
ajexpert
Flag of United States of America image

You cannot see the output of REF CURSOR in toad, you need to write a separate routine to see ref cursor values
ASKER CERTIFIED SOLUTION
Avatar of sventhan
sventhan
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial