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

What are inner and outer joins examples of both?

948

how do you control the max size of a heap table? : Sql dba

964

Explain the uses of control file.

1040

Do triggers have restrictions on the usage of large datatypes, such as long and long raw?

1155

What operating systems are supported by oracle sql developer?

945

What are the advantages of normalization?

1074

Explain table and field in sql?

1056

What do you know by pl/sql cursors?

1096

Can procedure in package be overloaded?

1072

Define union, minus, union all, intersect ?

996

What is a variable in sql?

990

how to install mysql? : Sql dba

1097

What is a pdo connection?

1019

What are the different dml commands in sql?

1160

What is sql comments?

1068