PLS-00123: Program too large error trying to compile package body with 16964 lines

[WexSoft]

I am trying to compile a package body which has 16964 lines (although there are many blank lines within the code) but PSD v7.1.5.1398 returns the above error. It compiles ok using TOAD which is destroying my argument for replacing our 120 TOAD seats with PSD.

 

[Marco Kalter]

If a compilation causes such an error and works correctly in other tools, then I suspect a problem with the "debug information" mode. To verify this, go to Tools > Preferences > Debugger tab page, disable the "Add debug information when compiling" option, and retry the compilation.

You can also explicitly exclude specific objects from debug information. On the same debugger tab page you can add a line with the name (or owner.name) of the program unit to the "NEVER add debug info for objects" list.

 

[WexSoft]

Thanks Marco - turning off the "Add debug information" option solved the problem.