OraFAQ Forum: SQL & PL/SQL » How to debug the trigger?

Home » SQL & PL/SQL » SQL & PL/SQL » How to debug the trigger?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to debug the trigger? [message #39621]

Fri, 26 July 2002 13:59

Cheng-Liang
Messages: 1
Registered: July 2002

Junior Member

Hi all

This is probably a very silly question but bother me for a while. I wrote a trigger and add it into the DB but sqlplus raise the trigger compilation problem but doesn't tell me where and why? Is there any way I can debug it? Thanks.

Report message to a moderator

Re: How to debug the trigger? [message #39622 is a reply to message #39621]

Fri, 26 July 2002 14:06

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

Well, if there is a compilation problem then you need to find out why it cannot compile successfully - debugging is only a runtime operation.

sql>alter trigger trigger_name compile;
sql>show errors

The 'show errors' command will display the error(r) in the trigger. If you cannot find the error, post your trigger here along with the error message.

Report message to a moderator

Previous Topic:	Custom Month-to-date Expression
Next Topic:	Urgent – Fundamental – Primary key

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Oct 29 20:12:03 CDT 2025