Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Trigger Size Restriction

dhmanSep 17 2019 — edited Sep 18 2019

I have a DB 18c. On below documentation it says that a trigger cannot exceed 32k.

https://docs.oracle.com/en/database/oracle/oracle-database/18/lnpls/plsql-triggers.html#GUID-832B47C3-9CF3-4EC8-B2CC-EF6…

I tested this and it allows me to create triggers larger than 32k.

Can someone explain to me how this restriction works?

SQL> SELECT * FROM user_object_size WHERE name ='TRIGGER1';

NAME                           TYPE               SOURCE_SIZE PARSED_SIZE  CODE_SIZE ERROR_SIZE
------------------------------ ------------------ ----------- ----------- ---------- ----------
TRIGGER1                       TRIGGER                  38674           0      49165          0

This post has been answered by Cookiemonster76 on Sep 17 2019
Jump to Answer
Comments
Post Details
Added on Sep 17 2019
9 comments
756 views