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
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
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.
Previous Topic: dynamic sql problem
Next Topic: UTL_FILE
Goto Forum:
  


Current Time: Fri Jul 30 08:51:25 CDT 2021