Maximum Cursor Issue
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