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
- 14551 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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.
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
How to get unique records from a table?
what is an alias command? : Sql dba
What is procedure function?
What is an exception in pl/sql?
What are analytic functions in sql?
What packages(if any) has oracle provided for use by developers?
how to include numeric values in sql statements? : Sql dba
Can we use threading in pl/sql?
What is the meaning of disabling a trigger?
What is foreign key in sql with example?
Differentiate between % rowtype and type record.
What are the ways on commenting in a pl/sql code?
Can we use views in stored procedure?
How to use sql statements in pl/sql?
What program will open a mdb file?
