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

How to run sql statements through the web interface?

980

What is sqlite format?

1104

Are subqueries faster than joins?

945

What is an escape character in sql?

977

What is natural join in sql?

916

Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?

966

what are wild cards used in database for pattern matching ? : Sql dba

1075

What is foreign key in sql with example?

888

Can we join same table in sql?

958

How do I turn a list into a table?

905

Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints

1020

Explain the savepoint statement.

1037

How many sql core licenses do I need?

879

What are the uses of sysdate and user keywords?

1045

What is an exception in pl/sql?

1005