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

Enlist some predefined exceptions?

1063

How can I make sql query run faster?

1018

Explain the difference between rename and alias?

1015

Are stored procedures faster than dynamic sql?

1046

What is indexing oracle sql?

1108

What is right join in sql?

1096

Is primary key always clustered index?

1023

What is sql stand for?

991

What are sql constraints?

1180

How is debugging done?

984

How many times can we commit in a loop?

1022

Why we use stored procedure instead of query?

999

what does the t-sql command ident_incr does? : Transact sql

1080

What is sql profiling in oracle?

1066

How do I view a table in sql?

1011