List, I have a trigger that is 2315 lines long and essentially one big long code block. The trigger compiles in an 8.1.7 instance, but not in a 8.1.6 instance. The error it gives is PLS-00123 Program too Large. These are on separate boxes. I have been reading on metalink about splitting the trigger into two pieces to cut down its size. Besides that, is there anything else to look at to get the trigger to compile.
David Ehresmann PerotSystems [EMAIL PROTECTED] 972.577.6236 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
