It is not possible. but if we want to put we use autonomous transaction.

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

Question Posted / chintu

Answer Posted / chintu

It is not possible. but if we want to put we use autonomous
transaction.

Is This Answer Correct ?

13 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Why join is faster than subquery?

1042

How do you delete duplicates in sql query using rowid?

891

What is sharding in sql?

915

How we can update the view?

1004

What is bulk collect in pl sql?

1018

What are the events on which a database trigger can be based?

1100

How do I restart sql?

912

How do I filter in sql profiler?

947

describe mysql connection using mysql binary. : Sql dba

992

what is a tablespace? : Sql dba

1004

What do you know by pl/sql cursors?

1034

How to connect a sql*plus session to an oracle server?

1079

What is compilation error in pl sql?

920

What is the difference between Union and Union all. Which is faster.

1340

How do you copy a table in sql?

1012