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

How long it takes to learn pl sql?

533

What are local and global variables and their differences?

589

Why do we use procedures in sql?

550

What are the parts of a sql statement?

556

What is string join?

559

what is the difference between rownum pseudo column and row_number() function? : Sql dba

620

What do you mean by query optimization?

552

Why do we need a foreign key?

551

How does index help in query performance?

566

What is difference between sql and excel?

517

What are sql commands?

505

what is myisam? : Sql dba

578

What plvcmt and plvrb does in pl/sql?

881

What is recursive stored procedure?

606

What is dynamic sql in pl sql?

497