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!

Warning: Trigger altered with compilation errors. Show errors doesn't work.

ActitudFeb 28 2008 — edited Feb 28 2008
Hello all.

I'm getting an error on a trigger.

It's the common error...

ORA-04098: trigger 'string' is invalid and failed re-validation..

And this is what happened when I tried to compile.

SQL> alter trigger schema.trigger_name compile;
Warning: Trigger altered with compilation errors.
SQL>show err;
No errors.

SQL> show errors trigger trigger_name;
No errors.


How can I see the errors during compilation?

Thanks.
Alex.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 27 2008
Added on Feb 28 2008
3 comments
13,852 views