Home » SQL & PL/SQL » SQL & PL/SQL » ORA-04031: unable to allocate 1024 bytes of shared memory
ORA-04031: unable to allocate 1024 bytes of shared memory [message #21518] Thu, 08 August 2002 23:26 Go to next message
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

Report message to a moderator

Re: ORA-04031: unable to allocate 1024 bytes of shared memory [message #21524 is a reply to message #21518] Fri, 09 August 2002 05:02 Go to previous message
ram kumar
Messages: 113
Registered: August 2002
Senior Member
hi mani,
it measn u ned to increae you shared pool size for the instance by specifying in th ini8.ora file...
regards
ram

Report message to a moderator

Previous Topic: query SQL
Next Topic: Using exp utility from a procedure or trigger
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Apr 17 20:57:18 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.