ORACLE trigger

[Brent Gillan]

Try making the trigger "before update". If the trigger fails, the update of the
original table will not be commited.

Aci Polajnar wrote:

> 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.

--
Brent Gillan
Aerocomp Solutions Inc.
mailto:bgillan@aerocomp.ca


= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.