Can you use a commit statement within a database trigger?
Answers were Sorted based on User's Feedback
Answer / charan
Hi this is charan...
Actually Not allowed TCL commands in trigger...but it is possible we are not use directly these commands...to over come this problem oracle introduced one concept is called "Autonomous Transactions" .through autonomous transaction we are using tcl commands in Trigger concept....This is according to my knowledge
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / karthik
yes, by autonomous transaction we can use commit.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / usingh
Yes, using AUTONOMOUS_TRANSACTION Pragma you can COMMIT and ROLLBACK.
Is This Answer Correct ? | 1 Yes | 1 No |
is there a tool to trace queries, like profiler for sql server?
How to execute a stored procedure in oracle?
Can a Tablespace hold objects from different Schemes ?
What is the difference between SQL and SQL Server?
12 RULES OF RDBMS
find out the third highest salary?
92 Answers CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon,
What is a cognitive schema?
What do you mean by a deadlock?
How to use values from other tables in update statements using oracle?
Display the order number and the number of months since the order was shipped for all orders that have been shipped in the last year (365 days). (Hint: Unshipped orders will have a null value).
How to insert multiple rows with one insert statement in oracle?
What are steps required to ENTER DATA INTO DWH?