SQL & PL/SQL

Hello, I'm using Oracle 9i db with the TORA 1.2.4 client tool and I have created a trigger which "executes successfully" (presumably this just means it compiled OK).

When I activate the trigger by using [in this case] an INSERT statement, my client produces the following error

<<< error message
ORA-04098: trigger 'COMMON.AUTO_USER_ROLES' is invalid and failed re-validation

insert into common.<ERROR>app_users (user_id,user_first_name,user_last_name)
values ('xxx1','xxx','xxx')
>>>

can anyone tell me how the heck I am meant to debug this trigger when it compiles with no problems?

If you want me to post the PL/SQL for the trigger I can, but I'm asking a general question of how to debug compiled triggers that won't work and "fail re-evaluation".


Tora is supposed to have a PL/SQL "debugger" but the interface is confusing and it doesn't seem to support triggers (I'm using Tora version 1.2.4).