Package Procedures with Ref_cursor as out Parameter
Posted: Tue 29 Jul 2008 17:10
I have a Problem with Packages. I have to build a frontend to a existing database. I Use TOraStoredProcedures.Depending on the IN-Parameters the OUT-Parameter Ref_Cursor is filled or not. If the ref_cursor isn't filled an error occurs "maximum open cursors exceeded". After that i cannot close the session any more, and a few unknown errors are raised.
Try except doesnt help. First execute then open also.It is not possible to ask with a query wether the ref_cursor should be filled or not. What can i do to get rid of the problem.
I use direct mode!
Please help me!
Try except doesnt help. First execute then open also.It is not possible to ask with a query wether the ref_cursor should be filled or not. What can i do to get rid of the problem.
I use direct mode!
Please help me!
