Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Storage Error while Executing function

574415Jan 20 2010 — edited Jan 20 2010
Hi friends,

I would like to have your suggestions,why the following error will occur during the function execution -


Error report:

ORA-06500: PL/SQL: storage error

ORA-06512: at "APPS.PWR_DIS_GLO_CUS_CREDIT_LMT_FN2", line 189

ORA-06512: at line 4

06500. 00000 - "PL/SQL: storage error"

*Cause: PL/SQL was unable to allocate additional storage. This message

normally appears with an ORA-4030 or ORA-4031 error which gives

additional information. Sometimes this error can be caused by

runaway programs.

*Action: 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.

Looking for your great help!

Thanks In Advance!

Thanks & Regards
Ramya Nomula
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 17 2010
Added on Jan 20 2010
3 comments
692 views