Database Administration (MOSC)

MOSC Banner

Rollback a transaction what happen to trigger

edited Jul 13, 2009 1:38AM in Database Administration (MOSC) 4 commentsAnswered
 Hi

I have a table EMP which has a trigger that will insert a row in DEPT whenever I insert a row in EMP, i also has another trigger on DEPT which will update table COUNTRY whenever i have row insert into DEPT.

When i have a insert transaction in EMP, it will cause insertion into DEPT and also update COUNTRY.

EMP -> DEPT -> COUNTRY

If i rollback transaction in EMP, will I also rollback the DEPT and COUNTRY?

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