RE: Dreaded PLS-123 Error
- From: "Reidy, Ron" <Ron.Reidy@xxxxxxxxxxxxxxxxxx>
- To: <post.ethan@xxxxxxxxx>, "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 9 Nov 2006 12:49:20 -0700
Can you split the trigger into smaller PL/SQL compilation units?
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
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.
Other related posts:
