Home » Developer & Programmer » JDeveloper, Java & XML » ORA-04030: out of process memory
ORA-04030: out of process memory [message #91901] Wed, 23 July 2003 00:52 Go to next message
Shyam Bhatia
Messages: 1
Registered: July 2003
Junior Member

We are facing a problem in calling a java stored procedure from a PL/SQL procedure.
The issue is :-

ERROR :-29532
The Error message is :ORA-29532: Java call terminated by uncaught Java
exception: oracle.xml.sql.OracleXMLSQLException: Invalid context handle
ORA-04030: out of process memory when trying to allocate 36876 bytes
BEGIN sfa_xml_generator_proc; END;

ERROR at line 1:
ORA-04030: out of process memory when trying to allocate 4032 bytes (joxu heap


The PL/SQL procedure continuously listening to an Advance Queue for any messages and calls the Java Stored Procedure for each message.

We are getting this error when the messages in the queue exceed 80 (appx).

1) Is there any limitation in Oracle for calling Java Stored Procedure?
2) If Java Stored Procedure consumes more of process memory?

Oracle version we are using is

Any pointers welcomed.

Re: ORA-04030: out of process memory [message #91902 is a reply to message #91901] Wed, 23 July 2003 12:24 Go to previous message
Mahesh Rajendran
Messages: 10706
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
increase your java_pool_size
Previous Topic: Transforming XML into another XML document !!!
Next Topic: Save XML Document....Help!!!!
Goto Forum:

Current Time: Fri Dec 02 17:13:39 CST 2022