Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Maximum Cursor Issue

martinleyAug 7 2009 — edited Aug 7 2009
Hi,

I am running an OA Framework page that looks at a PL/SQL package to display the majority of the data. When I run this, after a short while I am getting the below Error:

oracle.apps.fnd.framework.OAException: Message not found. Application: FND, Message Name: FND_MESSAGE_NOT_FOUND. Message not found. Application: FND, Message Name: FND_GENERIC_MESSAGE. Tokens: MESSAGE = java.sql.SQLException: ORA-01000: maximum open cursors exceeded

I have checked all my stored functions and I have made sure all cursors are closed, I have changed all SELECT INTO's into Cursors and OPEN-FETCH-CLOSE calls,
but I am still receiving the error.

Can anyone suggest anything else that I can check and possibly find out where the offending cursors are?

Many thanks

Martin
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 4 2009
Added on Aug 7 2009
11 comments
823 views