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.

In packages the source code is compiled into p code ? how do we describe the p code

3 Answers  

Is inner join same as self join?

0 Answers  

what are the forced views

6 Answers   Hexaware, TCS,

write a query to remove null following table are id name 101 dinesh null jyothi null bharathi 102 suresh null shilpha 103 prakesh null suma i want the output format like id name 101 dinesh 102 suresh 103 prakesh

3 Answers   TCS,

How do I run a program in pl sql?

0 Answers  

Why stored procedure is faster than query?

0 Answers  

Does pl/sql support create command?

0 Answers  

what is union, minus and interact commands? : Sql dba

0 Answers  

Can we insert data into materialized view?

0 Answers  

What is the difference between explicit and implicit cursors in oracle?

0 Answers  

How does cross join work in sql?

0 Answers  

What is trigger in pl sql with examples?

0 Answers