Trigger

[akhil]

Hi,

I am having a error in my database trigger. When i do show error i am unable to see the compilation errors. I have query user_errors to check the compilation. Is there any setting required at sqlplus level to see the error.

Thanks in anticipation.

[jmodic]

Try using full SHOW ERROR sintax:

SHOW ERROR TRIGGER trigger_name