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 synonyms in sql?

532

How to add a column ‘salary’ to a table employee_details?

586

what are ddl statements in mysql? : Sql dba

577

what is the difference between join and union? : Sql dba

545

What is the use of sqldataadapter?

532

Explain mutating table error.

645

What does the sign mean in sql?

505

What is difference between rank () row_number () and dense_rank () in sql?

575

What is use of trigger?

510

Which is the correct statement about truncate and delete?

525

Why query optimization is needed?

515

How does sql developer connect to oracle database?

516

What packages are available to pl/sql developers?

599

What are triggers and its types?

551

How do I run a pl sql program?

629