PLS-00123: program too large
Hello Friends...
I'm facing a problem just on Oracle 9.2.0.1.0. When I try to compile an object its says the program is too large. Actually the code has 7896 lines.
look:
SQL> @c:\trigger_ins
Trigger Created.
Criando Triger TRG_NOTAS_ITENS_INS
Warning: Trigger created with compilation errors.
SQL> SHOW ERR
Erros para TRIGGER TRG_NOTAS_ITENS_INS:
LINE/COL ERROR
-------- -----------------------------------------------------------------
7253/40 PLS-00123: program too large
SQL> SELECT * FROM V$VERSION;
BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
PL/SQL Release 9.2.0.1.0 - Production
CORE 9.2.0.1.0 Production
TNS for 32-bit Windows: Version 9.2.0.1.0 - Production
On oracle 10.2.0.1.0 it works:
SQL> @c:\trigger_ins
Trigger created.
Criando Triger TRG_NOTAS_ITENS_INS
Trigger created.
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production
Any tips? I checked some parameters but I could not figure out the proble.
Lots of threads says the problem is on pl\sql dev. but I'm using Sql Plus client.
Regards