I have a database just upgraded from 12c to 19c. Today I noticed there were some objects (packages & triggers) in invalid status. When I tried to compile one of simple trigger and I got the following errors: SQL> alter trigger RELEASE_LOCK compile; Warning: Trigger altered with compilation errors. SQL> show error Errors for TRIGGER … Continue reading Strange issue PL/SQL: SQL Statement ignored & ORA-00942 →