Interested to Buy Any Domain ? << Click Here >> for more details...
can we use commit in trigger? If yes how?
- 2 Answers
- 18426 Views
- Cap Gemini, TCS, I also Faced
- E-Mail Answers
Answer Posted / prasad reddy
Yes ,You can Commit inside the trigger.
But for this you have to make this trigger transaction to be
a Independent transaction from its parent transaction, You
can do this by using Pragma. Pragma AUTONOMOUS_TRANSACTION
allow you to build the Indepadent(child) Transaction,started
by another
Cheers
-Prasad
| Is This Answer Correct ? | 21 Yes | 1 No |
Post New Answer View All Answers
please send me forms, xml pulisher questions,answers
What is a value set? List its various types.
How can we import the data into a database using sql * loader?
What are do's and dont's of Interface?
Which oracle applications pl/sql standard apis you are familiar, have you used most of them?
What is count(*) from po_vendors(any table)?
WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?
How to move the one file from one instance to another instance? And your scripts also?
If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?
What do you understand by soa and what are the benefits of using this architecture?
Tell me how to debug the report?
In hierarchical structure of a database? we have write query from where we should start?
How to create a purchase order without a requisition?
What is the concept of soa governance?
how can develope the po variance and po summary report? with tables mandatory columns and query please?
