Package Procedures with Ref_cursor as out Parameter

Walter Weiss · Post by **Walter Weiss** » 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!

Plash · Post by **Plash** » Wed 30 Jul 2008 07:01

This problem is fixed in the latest ODAC build. You should download the latest build.

Walter Weiss · Post by **Walter Weiss** » Wed 30 Jul 2008 10:59

Thank You