Results 1 to 6 of 6
  1. #1
    Join Date
    Dec 2003
    Posts
    1,074

    Unanswered: PLS-00123 Program too large

    We're on Oracle 11.1.0.7, and a TRIGGER started throwing the PLS-00123 error on recompile. So, we stripped out about 1000 lines of commented code. Still the error. Then, after looking through some online posts, I tried commenting out some of the EXCEPTION handler. Now the code compiles. The EXCEPTION handler went from about 85 lines, to about 30 lines.

    The odd thing is, we didn't alter the exception handler at all in the last maintenance request.

    There's something weird going on here, as the trigger prior to the maintenance change is longer, and still compiles without problem.

    Confused ...
    --=Chuck

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >The odd thing is, we didn't alter the exception handler at all in the last maintenance request.
    But were a bunch of new code lines (50+) added to the procedure.
    The compiler just ignores comment lines.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Dec 2003
    Posts
    1,074
    There were new lines added. My bad, I didn't know that the compiler ignored comment lines.

    I went back in and removed something else, restoring the deleted lines from the exception handler, and the trigger compiled.

    Thanks for pointing that out.
    --=Chuck

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    consider refactoring the code into two procedures.
    It appears it is close to maximum the complier can handle.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Dec 2003
    Posts
    1,074
    It's a trigger which references :OLD and :NEW values, so I'm not looking forward to refactoring it. But, yeah, that's the direction we'll be heading.

    We're on 11g. Do you know if TRIGGERS and PACKAGES have the same size limit, or do PACKAGES have more growing room?

    --=Chuck

  6. #6
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    When all else fails, Read The Fine Manual!

    Logical Database Limits

    "PL/SQL and Developer/2000 may have limits on the size of stored procedures they can call. The limits typically range from 2000 to 3000 lines of code"
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •