We seem to have a java memory leak in our PL/SQL code somewhere. We must have a newXYZ without a freeXYZ or something because we're getting:
"ORA-29532: Java call terminated by uncaught Java exception: java.lang.OutOfMemoryError."
The problem is in a queue payload processing program. It uses AQ to dequeue an object containing a message type and an XML clob, parses the clob, processes it depending on the payload message type, and optionally creates another XML message for another queue.
I've reviewed the code in detail and have not found the source of the problem. Is there some trick to find out where the memory leak is occurring?