This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes Java in General and the fly likes Java Stored Procedure Issue Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Java » Java in General
Bookmark "Java Stored Procedure Issue" Watch "Java Stored Procedure Issue" New topic
Author

Java Stored Procedure Issue

Gaurav Mac Mathur
Ranch Hand

Joined: Feb 19, 2002
Posts: 47
Hi,
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 RA-29532: Java call terminated by uncaught Java
exception: oracle.xml.sql.OracleXMLSQLException: Invalid context handle
specified.
ORA-04030: out of process memory when trying to allocate 36876 bytes
(callheap,kllcqgf:k
BEGIN sfa_xml_generator_proc; END;
*
ERROR at line 1:
ORA-04030: out of process memory when trying to allocate 4032 bytes (joxu heap
init,ioc_allocate_pal)
********************************************
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 8.1.7.2
Any pointers welcomed.
TIA,
Gaurav
Avi Abrami
Ranch Hand

Joined: Oct 11, 2000
Posts: 1121

Gaurav,
You are running out of memory. I guess that your java code is not allowing the garbage collector to release memory. I would say your code is causing a memory leak. But without seeing your code, I can only guess.
Obviously (assuming my guess is correct) you have to rewrite your code so that it does not cause a memory leak!
Avi.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Java Stored Procedure Issue
 
Similar Threads
problem calling stored procedure
writing log to a file from java stored procedure
Problem calling IN parameters Stored Procedure from Java
ORA-29532 Error in Java Stored Procedure
Oracle ODBC Driver Problems. Please help