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 a database? : Sql dba

0 Answers  

what is the correct way of selection statement a. select/from/table_name/orderby/groupby/having b. select/from/table_name/groupby/having/orderby

5 Answers   HCL, JPMorgan Chase,

How do I run a sql trace?

0 Answers  

What is the purpose of normalization?

0 Answers  

How to convert lowercase letters to uppercase and uppercase letters to lowercase in a string. (ex, AbcdEfG should convert as aBCDeFg)

3 Answers   TCS,

What is rank dense_rank and partition in sql?

0 Answers  

declare l1 number := null; l2 number :=null; begin if l1=l2 then message('equal'); else if l1<>l2 then message('not equal'); else message('else'); end if; end if; end; What will be the output ?

7 Answers   Oracle,

how to convert dates to character strings? : Sql dba

0 Answers  

What are two statement types in sql?

0 Answers  

what is difference between pass by value and eference by value in oracle plsql

1 Answers  

What is pl sql block in dbms?

0 Answers  

Can we use join in subquery?

0 Answers