PL/SQL (MOSC)

MOSC Banner

Problem with after delete trigger

edited Dec 27, 2012 5:50AM in PL/SQL (MOSC) 1 commentAnswered
I need help to solve a problem with a trigger.
I have TABLE_A (A_item1, A_item2, A_item3) and TABLE_B (B_item1, B_item2). B_item1 references foreing key to A_item1.

I have made a after delete trigger on TABLE_A to make something in another application.

My problem is that only need to run the code in the trigger when delete is ok processed. When foreing_key error deleting TABLE_A raised, I no have to make something

How can I know in after_delete trigger if the delete has been processed ok ???

Thanks

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center