PL/SQL Autonomous Transaction

If in PL/SQL Autonomous transaction, you get error then how will you role back the main transaction?

Questions by tbala_soft

Showing Answers 1 - 3 of 3 Answers

oullagaddi

  • Sep 19th, 2009
 

Write the autonomous transaction?function to return its status (success or error).
Check the condition calling function/procedure then use Rollback command.

  Was this answer useful?  Yes

dhiren21

  • Sep 20th, 2009
 

Before this Ask a Question to your Self...
What are you Updating?
When You Updated this?
How you are updating?

Then?

Check the Commit?Point if commited not possible to rollback normally.

Steps :::?

Restore the Point in time Data and Import the Perticular table as on date and time..
Or
Write a Query to Find the Updated Data or change the Automated Query?Put the Updated data to a Temp table Before Updating a table which will be kept as a Record.

  Was this answer useful?  Yes

Mohammad Jarwan

  • Apr 9th, 2012
 

Used in table trigger to execute update statement for same table.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions