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
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

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
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...

Previous Topic: Reset Record Object
Next Topic: exluding records based on date
Goto Forum:

Current Time: Sun Aug 20 22:00:58 CDT 2017

Total time taken to generate the page: 0.03907 seconds