Home » SQL & PL/SQL » SQL & PL/SQL » ORA-06500: PL/SQL: storage error
icon7.gif  ORA-06500: PL/SQL: storage error [message #186801] Wed, 09 August 2006 11:44 Go to next message
santhoshml
Messages: 2
Registered: July 2006
Junior Member
Hello guys,

In our application, we retrieve data, concatenate (delimited string) and do some kind of sorting on the fields and send it to java. For concatenation purpouse, I declared a variable (varchar2)of length 32000 where I store the concatenated string. Recently when I collegue looked into logs its throwing lot of ORA-06500: PL/SQL: storage errors.

Any standard way to fix it ??

Is tht the variable of tht length reason for it ?? I think it shouldn't be becoz its varchar2.

Thanks in advance

Sunny
Re: ORA-06500: PL/SQL: storage error [message #186804 is a reply to message #186801] Wed, 09 August 2006 12:15 Go to previous message
navkrish
Messages: 189
Registered: May 2006
Location: NJ,USA
Senior Member

As you asked for the fix, below are some of the way to fix this error

1) Ensure there are no issues or bugs in your PL/SQL program which are causing excessive amounts of memory to be used.

2) Programmatically cause unused objects to be freed (e.g. by setting them to NULL).

3) Increase the amount of shared or process memory (as appropriate) available to you.

Truly speaking, I have taken up the above points from net...

Naveen
Previous Topic: Committing Large Amounts of Data
Next Topic: DBMS_LOB.SUBSTR
Goto Forum:
  


Current Time: Sat Dec 10 22:14:21 CST 2016

Total time taken to generate the page: 0.15701 seconds