Oracle database on trigger fail rollback

Posted by GigaPr on Stack Overflow See other posts from Stack Overflow or by GigaPr
Published on 2010-04-24T12:05:30Z Indexed on 2010/04/24 12:13 UTC
Read the original article Hit count: 148

Filed under:

triggers

|

Oracle

Hi

I want to create a trigger that execute on update of a table.

in particular on update of a table i want to update another table via a trigger but if the trigger fails (REFERENTIAL INTEGRITY-- ENTITY INTEGRITY) i do not want to execute the update anymore.

Any suggestion on how to perform this?

Is it better to use a trigger or do it anagrammatically via a stored procedure?

Thanks

© Stack Overflow or respective owner

Related posts about triggers

Instead of Triggers - Can they coexist with regular Triggers

as seen on Stack Overflow - Search for 'Stack Overflow'
Can Instead Of triggers co-exist with regular triggers? If so, are there any potential issues we should be aware of? >>> More
Ask Tom - "The Trouble with Triggers"

as seen on Oracle Technology Network - Search for 'Oracle Technology Network'
Protect sensitive information and achieve regulatory compliance with Oracle Database. >>> More
"On Redefinition, Nature, and Triggers"

as seen on Oracle Technology Network - Search for 'Oracle Technology Network'
Our technologist redefines tables, compares keys, and warns about DDL in triggers. >>> More
JDBC Triggers

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Received a question from a customer last week, they were using the new rollup patch on top of 10.1.3.4.1. What are these boxes for? Don't you know? Surely? Well, they are for ... that new functionality, you know it's in the user docs, that thingmabobby doodah. OK, I dont know either… >>> More
Retrieving Stored procedures, Views, Functions, Triggers using Toad for Oracle

as seen on Stack Overflow - Search for 'Stack Overflow'
How can I get the scripts of Stored procedures, Views, Functions, Triggers in toad for oracle? >>> More

Related posts about Oracle

E-Business Suite Technology Sessions at OpenWorld 2012

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Oracle OpenWorld 2012 is almost here! We're looking forward to updating you on our products, strategy, and roadmaps. This year, the E-Business Suite Applications Technology Group (ATG) will participate in 25 speaker sessions, two Meet the Experts round-table discussions, five demoground booths and… >>> More
26 Days: Countdown to Oracle OpenWorld 2012

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Welcome to our countdown to Oracle OpenWorld! Oracle OpenWorld 2012 is just around the corner. In less than 26 days, San Francisco will be invaded by an expected 50,000 people from all over the world. Here on the Oracle WebCenter team, we’ve all been working to help make the experience a great… >>> More
OTN ???? ?????? ???????

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Database ?? Database ??????? Database ?????????? Java WebLogic Server/????????·???? SOA/BPM/????? ???????/???? ID??/?????? ?????EPM/BI EPM/BI ??????? EPM/BI ???? OS/??? ???? ????? MySQL Database ?? ???? ?? ????????? ??? ?? ORACLE MASTER… >>> More
SOA PARTNER COMMUNITY NEWSLETTER JULY 2012

as seen on Oracle Blogs - Search for 'Oracle Blogs'
SOA PARTNER COMMUNITY NEWSLETTER JULY 2012 Dear SOA partner community member To provide our community members the best of our knowledge, we want your feedback on our SOA Partner community. Thus we are organizing SOA Partner Community Survey 2012. We… >>> More
Oracle ADF Coverage at OOW

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Below is the schedule for all ADF related sessions at a glance. Note the Meet and greet session added for Wednesday Octiber 3rd from 4.30 pm to 5:30. Oracle ADF and Fusion Development General Session Mon 1 Oct,… >>> More