Home » SQL & PL/SQL » SQL & PL/SQL » ORA-04030 executing PL/SQL with stored java
ORA-04030 executing PL/SQL with stored java [message #40778] Wed, 06 November 2002 08:14 Go to next message
Tanja
Messages: 4
Registered: October 2002
Junior Member
Hi,

I'm using Java-Stored-Procedures in a cursor-loop, after about 23000 iterations I get ORA-04030 error.
I changed java_pool_size and shared_pool_size but thas has no effect.

Has anybody got an idea?

Greetings
Tanja

Report message to a moderator

Re: ORA-04030 executing PL/SQL with stored java [message #40779 is a reply to message #40778] Wed, 06 November 2002 09:12 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
is it accompanied by any other errors?
ORA-06500??

Report message to a moderator

Re: ORA-04030 executing PL/SQL with stored java [message #40793 is a reply to message #40778] Thu, 07 November 2002 00:00 Go to previous message
Tanja
Messages: 4
Registered: October 2002
Junior Member
This is the error output:

FEHLER in Zeile 1:
ORA-04030: Zu wenig Prozessspeicher für Versuch 4032 Bytes zuzuweisen
(ioc_make_sub2,ioc_allocate_pal)
ORA-04030: Zu wenig Prozessspeicher für Versuch 120016 Bytes zuzuweisen
(,subheap)
ORA-06512: in "SYS.XMLTYPE", Zeile 0
ORA-06512: in "USER009.ZIPATTR", Zeile 74
ORA-06512: in "USER009.ZIPATTR", Zeile 168
ORA-06512: in "USER009.TESTZIPATTR", Zeile 22
ORA-06512: in Zeile 1

Greetings Tanja

Report message to a moderator

Previous Topic: Simple Where Condition is not working
Next Topic: Oracle error
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed May 08 03:51:31 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.