It is not possible. As triggers are defined for each table, if you use CO

Is it possible to use Transaction control Statements such a
ROLLBACK or COMMIT in Database Trigger ? Why ?

Question Posted / tulsi

Answer Posted / tulsi

It is not possible. As triggers are defined for each table,
if you use COMMIT of ROLLBACK in a trigger, it affects
logical transaction processing.

Is This Answer Correct ?

4 Yes

7 No

Please Help Members By Posting Answers For Below Questions

What is spool?

1045

What are predefined functions in sql?

1036

Why do we need view in sql?

977

what are the type of locks ? : Sql dba

956

What is trigger price?

976

Is sql between inclusive?

1116

Can we have two clustered index on a table?

1018

How can one get sql*loader to commit only at the end of the load file? : aql loader

1051

What is a system versioned table?

975

What are the different types of functions in sql?

1044

What does fetching a cursor do?

1077

How does a self join work?

1099

what are null values? : Sql dba

946

How does a covering index work?

953

How would you pass hints to the sql processor?

975