Skip to Main Content

SQL Developer

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!

PLS-00123 Program too large

Ernst LeberDec 12 2007 — edited Jan 4 2008
I am getting an error, when I compile a package body having 2670 lines:

PLS-00123 programm too large.

When using sqlplus it works fine.

also compiling with
ALTER PACKAGE mm301k08 COMPILE BODY;
ALTER PACKAGE mm301k08 COMPILE DEBUG BODY REUSE SETTINGS;

in a SQL-worksheet does not work.

If I compile a package body with even more lines (4400) this package will compile!

Target database is :
select * from v$version;
BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
PL/SQL Release 9.2.0.8.0 - Production
CORE 9.2.0.8.0 Production
TNS for IBM/AIX RISC System/6000: Version 9.2.0.8.0 - Production
NLSRTL Version 9.2.0.8.0 - Production

SQL Developer Version:
1.2.1.3213
Java Platform :1.5.0_06

Any ideas, or am I missing something here?

Thanks
Ernst
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 1 2008
Added on Dec 12 2007
3 comments
8,238 views