Answer / chintu

It is not possible. but if we want to put we use autonomous
transaction.

Answer / deva

yes we cannot make TCL commands with in triggers. If the
block is declared as a autonomous transaction, then commit
and rollback can be given in the end of the block

Answer / aravinda

We can't write COMMIT or ROLLBACK in triggers, because the
triggering event may commit or may not. trigger commit or
rollback is based on triggering event.

even we can't call a subprogram in a trigger which is having
commit or rollback.

but we can achieve through pragma autonomous transaction.

Answer / nishi

We can't write COMMIT or ROLLBACK in triggers, because the triggering event may commit or may not. trigger commit or rollback is based on triggering event.

even we can't call a subprogram in a trigger which is having commit or rollback.

but we can achieve through pragma autonomous transaction.

Answer / tulsi

It is not possible. As triggers are defined for each table,
if you use COMMIT of ROLLBACK in a trigger, it affects
logical transaction processing.

How do I count duplicates in sql?

0 Answers  

What is difference between stored function and application function?

0 Answers  

What is use of package in pl sql?

0 Answers  

Is pl sql better than sql?

0 Answers  

What is faster join or subquery?

0 Answers  

Is sql a oracle?

0 Answers  

what are dynamic queries in t-sql? : Transact sql

0 Answers  

What are the basic techniques of indexing?

0 Answers  

Do foreign keys improve performance?

0 Answers  

if we give update table_name set column_name= default. what will happen? its given in pl sql block.what will hapen?

5 Answers   iFlex,

i need department wise top 2 employees salary.which logic i will use

17 Answers  

What is the purpose of using pl/sql?

0 Answers