RE: Dreaded PLS-123 Error

From: Reidy, Ron <Ron.Reidy_at_arraybiopharma.com>
Date: Thu, 9 Nov 2006 12:49:20 -0700
Message-ID: <7209E76DACFED9469D4F5169F9880C7A2835AF@mail01bldr.arraybp.com>

Can you split the trigger into smaller PL/SQL compilation units?

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Ethan Post Sent: Thursday, November 09, 2006 12:38 PM To: oracle-l
Subject: Dreaded PLS-123 Error

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

This electronic message transmission is a PRIVATE communication which contains information which may be confidential or privileged. The information is intended to be for the use of the individual or entity named above. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. Please notify the sender of the delivery error by replying to this message, or notify us by telephone (877-633-2436, ext. 0), and then delete it from your system.

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Nov 09 2006 - 13:49:20 CST