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.

Is trigger a stored procedure?

0 Answers  

Can we use pl sql in sql server?

0 Answers  

What are the datatypes a available in PL/SQL ?

2 Answers  

how to use like conditions? : Sql dba

0 Answers  

what are the security recommendations while using mysql? : Sql dba

0 Answers  

Define commit?

0 Answers  

What does “select count(1) from tab” result?

10 Answers   IBM,

Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

0 Answers  

How to retrieve a second highest salary from a table? Note:Suppose salaries are in duplicate values eg: Name Sal Malli 60000 Pandi 60000 Rudra 45000 Ravi 45000

10 Answers   Mind Tree, Polaris, Sonata,

What is normalization in sql?

0 Answers  

i have a word ***********hello********world******. I require a o/p **********hello world**********, Need to delete the middle stars.

3 Answers  

how many columns can be used for creating index? : Sql dba

0 Answers