Interested to Buy Any Domain ? << Click Here >> for more details...
Can i use Commit inside the Trigger? Suppose i use commit
what will be happy (it's complied /executed/work)
- 6 Answers
- 14805 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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;
/
| Is This Answer Correct ? | 18 Yes | 0 No |
Post New Answer View All Answers
What is synchronized subquery?
What are the main features of cursor?
Does access use sql?
What is structural independence and why is it important?
What mean sql?
What is the least restrictive isolation level? : Transact sql
What are crud methods?
How can we find duplicate records in a table?
What does trigger mean in psychology?
What are the sql aggregate functions?
What is not equal in sql?
What is sql key?
what are the advantages of sql ? : Sql dba
what is a cursor? : Sql dba
What is the command used to fetch the first 5 characters of a string?
