PL/SQL (MOSC)

MOSC Banner

Trigger Events

edited Dec 24, 2014 10:03AM in PL/SQL (MOSC) 6 commentsAnswered

Dear All

I have two table ABC and XYZ. An AFTER INSERT has been applied to both tables FOR EACH ROW. I want to capture updated value of table ABC of ColumnA. But problem is that table ABC is updated after XYZ. A procedure is being run through table XYZ. I want if ColumnA is updated then trigger of XYZ should not fired. How is this possible??

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