SQL & PL/SQL

Hi Friends,

I have a trigger on a table and the trigger calls a procedure.

I have added a few debug statements in both procedure and trigger and recompiled both of them.

Now, the trigger errors out with the above error message.

I have checked the status of trigger and package and they are VALID.

Before adding the debug statements, everything was working fine. I am wondering how a debug statement can result in this problem?

At this stage, i have reverted the code to the original one. But even then i am getting the same error.

Please advise me on this.

Regards,
Sreekanth Munagala.