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