Dreaded PLS-123 Error
- From: "Ethan Post" <post.ethan@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 9 Nov 2006 13:38:23 -0600
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
Other related posts:
