Dreaded PLS-123 Error

From: Ethan Post <post.ethan_at_gmail.com>
Date: Thu, 9 Nov 2006 13:38:23 -0600
Message-ID: <357b48a90611091138r1f42e118v2378bfe0ae7ec7eb@mail.gmail.com>

I am getting PLS-123 trying to compile a large audit type trigger on a table with about 300 columns. There was a fix for 10.1 which I tried (setting event 10946) but that is not working (that bug is fixed in 10.2 anyway but thought I would try anyway). Anyway this is not the first time I have ever seen this but in the past we is related to a package being compiled in debug mode or something, once we stopped that it was fine. However, this one is not in debug mode and we are seeing the problem. Looking around AskTom, Google and Metalink I don't find a lot of reason for hope here, they all seem to say, yes there are limits, you have hit the limit...the end.

Is there any reason to think otherwise?

SQL*Plus: Release 10.2.0.2.0 - Production on Thu Nov 9 13:30:02 2006

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production With the Partitioning, OLAP and Data Mining options

SQL> @some_trigger.sql

Warning: Trigger created with compilation errors.

SQL> show errors
Errors for TRIGGER ...

LINE/COL ERROR
-------- -----------------------------------------------------------------
1720/47 PLS-00123: program too large (Diana nodes) SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0- 64bit Production
With the Partitioning, OLAP and Data Mining options

Parameters (parms.sql)

Name                                          Value


---------------------------------------------

----------------------------------

event                                         1017 trace name errorstack
level
                                              12, 10946 trace name context
                                              forever, level 128

--

http://www.freelists.org/webpage/oracle-l Received on Thu Nov 09 2006 - 13:38:23 CST