PLS-00123

[jortiz]

Hello, I'm trying to compile a package in plsql developer, but I get the error:

PLS-00123: program too large

But when I do It in SQL PLUS, It compiles OK !!

Why I can't compile this with my plsql developer? Is there any way to solve the problem ?

 

[Marco Kalter]

Perhaps this topic applies? The symptoms are slightly different, but my guess is that it has the same cause.

Note that if you are using PL/SQL Developer 6.0.x, you can add this package to the "NEVER add debug debug info for objects" list on the debugger preference page. This way you can omit debug info for individual packages instead of all packages.

 

[jasonvogel]

Okay, this is an Oracle bug, not PL/SQL Developer. I spent hundreds of hours on this issue. It has to do with the underlying object count coming out of the LINDA (aka, ADA) based language that PL/SQL is based on. Marco is correct in that you have the "Compile with Debug" switch set to true. You can recreate this bug in SQL-Plus by

alter session set plsql_debug=true;

And then compiling your code...go boom.

Here is my Metalink posting : http://metalink.oracle.com/metalink...howDocument?p_database_id=FOR&p_id=490542.995

Well, here is the update.

Well my TAR finally is closed, but not resolved. It is tied back to a bug starting in 8.0.5, that may be fixed in 10G.

My TAR : http://metalink.oracle.com/metalink/plsql/tar_main.this_tar?tar_num=3445301.995&p_ctryCode=840
Original Bug : http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=BUG&p_id=709811

Jason

 

[jortiz]

Thats It !!!! I solved the problem

Thanks !!!