Error "PLS-00123: program too large" when compiling with debug mode (4312706)

When trying to compile with debug mode on, it fails with the error:

"PLS-00123: program too large error".

The package compiles OK in SQL*PLUS using 'Alter package <package_name> compile;'

and this error did not occur in previous versions of Toad for Oracle Standard.

This error maybe a limitation of the PL/SQL compiler. It appears that when you compile this package with debug information it either causes the package or one of the dependent objects to exceed the maximum block size that Oracle allows.

Note: This issue may only have arisen within Toad after upgrading to 9.6.1 since the debugger functionality is now provided as standard, and the option 'Compile with debug' is checked by default.

This has been found to be an Oracle issue.  

If debugging is not required, then this feature can be turned off in order to compile the package by , either clicking the 'bug' icon,  or Session | Toggle Compiling with debug.

If debugging is required, please consult Oracle as to a possible resolution to your issue.

Steps to replicate in SQL*Plus:

*To view the error associated with previously created procedural objects, such as Packages, you will need to query sys.USER_ERRORS view directly. You will need to query this view since a package compilation that results in an error does not display the package body's error when you execute the show error command. If you don't have rights to query the USER_ERRORS view you will need to ask to be granted this privilege.


1. To compile the package WITHOUT debug in SQL*Plus please type the following queries:

ALTER PACKAGE ObjectName;
select * from sys.user_errors where name='ObjectName';

You should get the following message:
no rows selected


2. To compile the package WITH debug on in SQL*Plus, please type the following queries:

ALTER PACKAGE ObjectName COMPILE DEBUG BODY;
select * from sys.user_errors where name='ObjectName';

You should get the following information.

NAME TYPE SEQUENCE LINE POSITION TEXT
------------------------------ ------------ ---------- ---------- ---------- --------------------------------------------------------------------------------

ObjectName; PACKAGE BODY 1 0 0 PLS-00123: program too large