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 user defined functions?

0 Answers  

How does one use sql*loader to load images, sound clips and documents? : aql loader

0 Answers  

If a View on a single base table is manipulated will the changes be reflected on the base table?

5 Answers  

how many no of table can be join in a sql query.

4 Answers  

Which kind of parameters cannot have a default value in pl sql?

0 Answers  

how to convert numeric values to character strings? : Sql dba

0 Answers  

How does a self join work?

0 Answers  

write a query to display diference between two dates in sql server

2 Answers  

7. Where would you look for errors from the database design?

1 Answers   Fintellix,

Can we create a trigger on view?

0 Answers  

What is a ddl command?

0 Answers  

I have a small PL/SQL Block assume in this way begin select * from emp where empno=100; exception when others then <Some Messages> when no_data_found then <Some Messages> when too_many_rows then <Some Messages> end; The question which he asked was whether this block will get executed normally or it will throw error ? If errored out then what is the reason for the error ? Could anybody please help me ? Regards Nakul Venkataraman

3 Answers   Satyam,