Is it possible to use Transaction control Statements such a
ROLLBACK or COMMIT in Database Trigger ? Why ?
- 5 Answers
- 15985 Views
- I also Faced
- E-Mail Answers
Answer Posted / aravinda
We can't write COMMIT or ROLLBACK in triggers, because the
triggering event may commit or may not. trigger commit or
rollback is based on triggering event.
even we can't call a subprogram in a trigger which is having
commit or rollback.
but we can achieve through pragma autonomous transaction.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
how many sql ddl commands are supported by 'mysql'? : Sql dba
Can procedure in package be overloaded?
What is dba in sql? : SQL DBA
Differentiate between pl/sql and sql?
How to avoid duplicate records in a query?
What is the difference between union and union all command?
How can we debug in PL/SQL?
Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?
what is data manipulation language? : Sql dba
what are properties of a transaction? : Sql dba
Is natural join and inner join same?
What is snowflake sql?
how to convert dates to character strings? : Sql dba
how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba
Can you selectively load only those records that you need? : aql loader
