50.000 Codelines working ?

[oracle4you]

I am was asked for follow. Can PL/SQL Developer version 7.x handel 50.000 Coderows in a Session.
A User asked me. His Applikation has a Packgage and in this are 35.000 Coderows at this time. In the next Monts he plans the bigger sizing to 45 oder 50.000 coderows. Not wundering ! I should give a answer in a short time.
Have anywhere a packgage wit this many coderows tested or can give a answer how many coderows PL/sql Devloper can handle ?
We have a companylicense !
Thanks for all answer. Sorry for my litle english. I can better read then write (smile)

 

[Marco Kalter]

PL/SQL Developer does not impose any limitation on package sizes. However, the Oracle Server may raise a "program too large" error if a package is too large. This depends on the Oracle Server version, but also on the "Add debug information when compiling" preference. You can explicitly exclude specific objects from debug information if you go to the debugger preference page and add a line with the name (or owner.name) of the program unit to the "NEVER add debug info for objects" list.