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.

What is Collation Sensitivity ? What are the various type ?

0 Answers  

What are packages in pl sql and also explain its advantages?

0 Answers  

Difference between IN and EXISTS

4 Answers   Nous, Polaris,

What happens if a procedure that updates a column of table X is called in a database trigger of the same table ?

1 Answers  

Explain spool.

0 Answers  

How much does sql cost?

0 Answers  

What is the difference between the sql*loader and import utilities? : aql loader

0 Answers  

What is the criteria while applying index to any column on any table.

1 Answers   Infogain,

Explain the select statement in sql?

0 Answers  

What are aggregate and scalar functions?

0 Answers  

What is a full join sql?

0 Answers  

Which is better stored procedure or query?

0 Answers