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 truncate is used in sql?

539

What is sql architecture?

567

what is top in tsql? : Transact sql

553

what are the authentication modes in sql server? : Sql dba

547

Does execute immediate commit?

706

how can we optimize or increase the speed of a mysql select query? : Sql dba

517

Can we update views in sql?

543

What is varchar data type in sql?

527

What problem one might face while writing log information to a data-base table in pl/sql?

568

Is big data nosql?

523

Is ms sql traffic encrypted?

511

Can cursors be part of a trigger body?

1131

Is not null in sql?

572

Can you join views in sql?

557

Can we use ddl statements in stored procedure?

705