ORA-04031: unable to allocate 1024 bytes of shared memory [message #21518] |
Thu, 08 August 2002 23:26 |
mani
Messages: 105 Registered: September 1999
|
Senior Member |
|
|
Hi,
I have created some 10 procedures each of having 3600 lines.Now i have created one procedure to call all the above ten procedures.
but am getting the following error while creating the last procedure....
CREATE OR REPLACE PROCEDURE PROC_URT_CITY_BUILD_TABLE IS
*
ERROR at line 1:
ORA-04031: unable to allocate 1024 bytes of shared memory ("shared
pool","PROC_URT_CITY_ML_LRATT","PL/SQL DIANA","PAR.C:parapt:Page")
Any idea...
Thanks in advance
Mani
|
|
|
|