Home » SQL & PL/SQL » SQL & PL/SQL » Pl/SQL Store procedure size too large -PLS-00123
Pl/SQL Store procedure size too large -PLS-00123 [message #37183] Tue, 22 January 2002 23:33 Go to next message
SS
Messages: 46
Registered: November 2001
Member
Hi,
I'm using Oracle 8.1.7.0.0 Database.

I'm running a Stored Procedure of around 3100 lines (160 KB). when I try to compile it, it is giving me 'PLS-00123: program too large' error.
I think the PLSQL block has exceeded the block size allocated for it.
Is there any solution for it?

Thanks

Report message to a moderator

Re: Pl/SQL Store procedure size too large -PLS-00123 [message #37186 is a reply to message #37183] Wed, 23 January 2002 04:31 Go to previous messageGo to next message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
Hi,

The source code size limitations are :

Up to 7.3: 4*(2**14)=64K
From 8.0 to 8.1.3: 4*(2**15)=128K
With 8.1.3: 4*(2**25)=256M

Check the source size from user_object_size.
Also check the compatible parameter set in initSID.ora

cheers
pratap

Report message to a moderator

Re: Pl/SQL Store procedure size too large -PLS-00123 [message #37188 is a reply to message #37183] Wed, 23 January 2002 07:55 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
You should really consider breaking your code up into smaller blocks. Also, packages should be used to house your procs and functions - source management is much easier and they come with numerour advantages including global variables.

Report message to a moderator

Previous Topic: dynamic sql problem
Next Topic: UTL_FILE
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Apr 15 23:39:50 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.