ORACLE trigger

Aci Polajnar Aci.Polajnar@rcc-irc.si
Thu, 26 Aug 1999 12:36:28 +0200


Hi there!

I am running simple PowerHouse screen, updating only one ORACLE table.
There is also an post_update trigger, writen for my table, which just
copies entered data to another table. Problem is that sometime trigger
fails, but my original table is already updated and commited.

How can I catch this situation and rollback my original table?
Any ideas? 

-- 
-------------------------------------------------------------
Aci Polajnar                  Tel   : +386(0)63 441144
IS Consultant                 Fax   : +386(0)63 442036
Razvojni Center Celje         e-mail: acip@rcc-irc.si
3000 Celje, Slovenia          URL   : http://www.rcc-irc.si
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.