Error: PLS-00123: program too large (Diana nodes)

[Huib-Jan Kwakernaak]

Hello,

After compiling a large package we get the following error:

Error: PLS-00123: program too large (Diana nodes)

The options: Add debug information and Safe compilation are off.

We're using PL/SQL Developer 7.1.4.194 with Oracle 10.2

Any idea?

regards Huib-Jan

 

[mike]

If it was me, I would try to compile it using SQL+. If it failed there, the package is just too large. Since you have add debug information off, my guess is that is the case. If so, you need to break it up into 2 or more packages.

 

[Huib-Jan Kwakernaak]

Compiling with PL/Edit from Benthic Software is going well.

After adding additional PL/SQL code it will compile again. So that's quite strange.

 

[W. Kroeker]

Disable "Add debug information ..." in Preferenzes, then PLSQL Developer compiles like "SQL+" without debug information. Debug informations increase the size of compiled code.