ORACLE trigger

[Robert J.M. Edis]

G'day Aci

I think you are the first PowerHouse site I've seen on this list from
Eastern Europe.  That's great.

Could your second Oracle table be included on the Quick screen as a
SECONDARY file?  That way if the update to it fails, the write to the
PRIMARY file will rollback so no change is written to either table.

What version of Oracle RDBMS are you using, Rdb, 7 or 8?

Blue 

-----Original Message-----
From: Aci Polajnar
To: 'PowerHouse List'
Sent: 8/26/99 6:36 AM
Subject: ORACLE trigger

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