Home » SQL & PL/SQL » SQL & PL/SQL » Error Message (Oracle10g)
icon9.gif  Error Message [message #550422] Mon, 09 April 2012 07:54 Go to next message
annuar
Messages: 3
Registered: April 2012
Location: Malaysia
Junior Member
first of all,im sorry to my bad bad english...
Im create one procedure call it loadutopen:

Package spec. & body

and im run thats procedure : exec fds_fin_load.loadutopen(5);
with data need to load arround 8million records.

After im run that procedure im got this error:

ERROR at line 1:
ORA-04030: out of process memory when trying to allocate 32792 bytes (QERHJ
hash-joi,QERHJ Bit vector)
ORA-06512: at "FDSDM21.ORA_PKREF", line 8
ORA-06512: at "FDSDM21.FDS_FIN_LOAD", line 1454
ORA-01403: no data found
ORA-06512: at line 1

can anyone tell me where my part at procedure causes a problem..

[EDITED by LF: applied [spoiler] tags; fixed topic title typo; was "massage" ./fa/450/0/]

[Updated on: Mon, 09 April 2012 11:17] by Moderator

Report message to a moderator

Re: Error Massage [message #550423 is a reply to message #550422] Mon, 09 April 2012 07:59 Go to previous messageGo to next message
joy_division
Messages: 4453
Registered: February 2005
Location: East Coast USA
Senior Member
I myself don't have the time to find line 1454. You need to show you SQL session with a cut and paste of your execution in SQL*Plus.
One thing looks like you are not using proper exception handling for NO_DATA_FOUND.
Re: Error Massage [message #550429 is a reply to message #550423] Mon, 09 April 2012 08:24 Go to previous messageGo to next message
BlackSwan
Messages: 21938
Registered: January 2009
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/
Re: Error Massage [message #550440 is a reply to message #550422] Mon, 09 April 2012 08:58 Go to previous messageGo to next message
Michel Cadot
Messages: 57603
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-04030: out of process memory when trying to allocate %s bytes (%s,%s)
 *Cause:  Operating system process private memory has been exhausted


Oracle is the victim not the culprit.
Increase OS stack limit for Oracle.

Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.

Regards
Michel
Re: Error Massage [message #550442 is a reply to message #550440] Mon, 09 April 2012 09:02 Go to previous messageGo to next message
annuar
Messages: 3
Registered: April 2012
Location: Malaysia
Junior Member
ok im reading now for Forum Guide...sorry,because this is my first time using this help...
Re: Error Massage [message #550508 is a reply to message #550442] Tue, 10 April 2012 00:12 Go to previous messageGo to next message
annuar
Messages: 3
Registered: April 2012
Location: Malaysia
Junior Member
Im still stuck with this error message. T_T
Re: Error Massage [message #550513 is a reply to message #550508] Tue, 10 April 2012 00:51 Go to previous messageGo to next message
Michel Cadot
Messages: 57603
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Michel Cadot wrote on Mon, 09 April 2012 15:58
ORA-04030: out of process memory when trying to allocate %s bytes (%s,%s)
 *Cause:  Operating system process private memory has been exhausted


Oracle is the victim not the culprit.
Increase OS stack limit for Oracle.
...
Regards
Michel

Re: Error Massage [message #550533 is a reply to message #550513] Tue, 10 April 2012 03:23 Go to previous messageGo to next message
cookiemonster
Messages: 10571
Registered: September 2008
Location: Rainy Manchester
Senior Member
Actually that's not the problem.
The first loop has no exit so will be an infinite loop.
Re: Error Massage [message #550537 is a reply to message #550533] Tue, 10 April 2012 03:32 Go to previous message
Michel Cadot
Messages: 57603
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
...I can't read not formatted code... Wink

Regards
Michel
Previous Topic: Unzipping the file in BLOB column
Next Topic: How to pass in dynamic variable for calling store procedure
Goto Forum:
  


Current Time: Wed Apr 16 18:08:39 CDT 2014

Total time taken to generate the page: 0.11937 seconds