Problem with procedures returning a SYS_REFCURSOR which is not open/executed - possible fixes

2013-01-11 Thread Martin J. Evans
I am using DBD::Oracle and calling a procedure which returns a reference cursor. However, sometimes the reference cursor is not opened and only the procedure knows this. The problem is if I call the procedure from DBD::Oracle and the cursor is not opened I get an Oracle error saying the cursor

RE: Problem with procedures returning a SYS_REFCURSOR which is not open/executed - possible fixes

2013-01-11 Thread John Scoles
Hmm you sure pick the head scratchers. My first thoughts where why whould you make such a procedure?? But then I relaisze it could have some use when prototying/develpopeing ect. Looking at 'DBD::Oracle attempts to describe statements which are initialized but not executed' We might be