Answer / saraswathi muthuraman

Trigger will be compiled. while execution r error will occur.
To avoid this you can use PRAGMA autonomus_transaction

example :

create or replace trigger emp_test_trig
after update on emp_test
for each row
declare
PRAGMA autonomus_transaction;
begin

insert into dep_test values(100,:new.emp_id);
commit;
end;
/

Answer / saravanakumar

you can commit trigger if the declaration part contains
autonomus transaction

Answer / kannan

By using PRAGMA autonomus_transaction we can use commit
inside the trigger.

Answer / swapna

commit,rollback and savepoint cannot be used in a trigger
directly, but it can be called in a stored procedure
present in the trigger. however it is usually avoided as it
might have sideeffects in transactions.

Answer / suresh babu

You cannot use the commit inside the trigger,because the
Transaction Control Languages(TCL) are not allowed in trigger.

Answer / coolpankaj

You can not use Commit Inside Trigger. It will not get complied.

Is it possible to use Transaction control Statements such a ROLLBACK or COMMIT in Database Trigger ? Why ?

5 Answers  

what is the difference between inner and outer join? Explain with example. : Sql dba

0 Answers  

How do you display "13th of November, 17 days left for month end" without hardcoding the date.

3 Answers  

What is the difference between union and union all command?

0 Answers  

Is it possible to use LONG columns in WHERE clause or ORDER BY?

3 Answers  

What is the difference between the implicit and explicit cursors?

0 Answers  

How is indexing done in search engines?

0 Answers  

why sql is used as interpreter frequently rather than a compile?

1 Answers  

what is meant by databases

4 Answers  

Why does sql need a server?

0 Answers  

What is information schema in sql?

0 Answers  

Is clustered index a primary key?

0 Answers