Home » Developer & Programmer » JDeveloper, Java & XML » ORA-04030 with PL/SQL java calls to CAPSCAN
ORA-04030 with PL/SQL java calls to CAPSCAN [message #91386] Mon, 05 August 2002 03:54 Go to next message
Nigel Rayson
Messages: 1
Registered: August 2002
Junior Member
We are have an Oracle 8.1.7 database on Windows 2k. We run a PL/SQL package that calls a geocoding product CAPSCAN via Oracle's jvm. The package essentially assigns a full address to a record. After 10,000 records the package fails with:

SQL> exec cmg_cris.a00_process_whole_batch;
BEGIN cmg_cris.a00_process_whole_batch; END;

*
ERROR at line 1:
ORA-04030: out of process memory when trying to allocate 27052 bytes (joxcx
callheap,ioc_allocate free)
ORA-04030: out of process memory when trying to allocate 16420 bytes (pga
heap,ksm stack)
ORA-04030: out of process memory when trying to allocate 16524 bytes (pga
heap,ksm stack)
ORA-06512: at "DIANE_PROCESS.DIANE_UTILS", line 1018
ORA-06512: at "DIANE_PROCESS.CMG_CRIS", line 2154
ORA-04030: out of process memory when trying to allocate 16396 bytes (pga
heap,ksm stack)
ORA-06512: at line 1

Are there any known memory leak problems for Capscan and or the Oracle jvm
Re: ORA-04030 with PL/SQL java calls to CAPSCAN [message #91759 is a reply to message #91386] Thu, 06 February 2003 04:49 Go to previous message
Chris
Messages: 128
Registered: November 1998
Senior Member
We are having the same issue, has anyone found a fix or workaround?
Previous Topic: how to scroll in the ms-dos window?
Next Topic: java.sql.Exception: Connection refused java
Goto Forum:
  


Current Time: Fri Mar 29 01:36:06 CDT 2024