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 are all the common sql functions?

0 Answers  

What is time based sql injection?

0 Answers  

How do I quit sql?

0 Answers  

Can I learn sql in a week?

0 Answers  

How many types of keys are there in sql?

0 Answers  

What are the advantages of sql?

0 Answers  

there is A table and B table in A table there 5 rows and in b table there are 2 rows i am firing query select * from a,b what will be the output?

7 Answers   Cognizant,

How do I run a script in sql developer?

0 Answers  

how view used for security purposes?

3 Answers   Glam India,

How to check if a column is nullable before setting to nullable?

0 Answers  

How do you retrieve the second highest salary from a table?

3 Answers  

i want run a sql query query? which phases are run in a back ground? pls tell me the answer

1 Answers