OraFAQ Forum: Server Administration » Update trigger not working....

Home » RDBMS Server » Server Administration » Update trigger not working....

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

Update trigger not working.... [message #372995]

Wed, 21 March 2001 12:12

ash
Messages: 43
Registered: February 2001

Member

I have two triggers on a table before and after update and the I am inserting the before and after updated values into an audit table. For some reason, only the before update trigger is getting triggered twice and there are two similar rows in the audit table. Any guess as to what might be happening. Thanks for the help.

Report message to a moderator

Re: Update trigger not working.... [message #373001 is a reply to message #372995]

Wed, 21 March 2001 19:11

Andrew again...
Messages: 270
Registered: July 2000

Senior Member

Have you checked in USER_TRIGGERS to make sure that you don't have 2 "before update" triggers?

Try putting debug statements into the triggers to see what's happening. e.g. dbms_ouput.put_line('Trig. xyz Upd fired');

Report message to a moderator

Re: Update trigger not working.... [message #373007 is a reply to message #372995]

Wed, 21 March 2001 23:56

Priya Rajkumar
Messages: 5
Registered: March 2001

Junior Member

Try debugging the Trigger as andrew said, also send the trigger text and the statement which triggers it.

Report message to a moderator

Previous Topic:	Cascade Update !!!
Next Topic:	Re: converting Access query to SQL (for oracle)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jun 26 06:50:13 CDT 2024