Discussion Board

Oracle Transaction Yes, the above statement is true. Suspending a statement automatically results in suspending the transaction. Thus, all transactional resources are held during a statement suspend and resume. When the error condition disappears, the suspended statement automatically resumes execution. A resumable space allocation can be suspended and resumed multiple times during execution. A suspension timeout interval is associated with resumable space allocations. A resumable space allocation that is suspended for the timeout interval (the default is two hours) wakes up and returns an exception to the user. A suspended statement may be forced to throw an exception using the DMBS_RESUMABLE.ABORT() procedure. Prajakta Pandit 02-17-2017 03:12 AM

Write your comments

*

* Email must be in the form someone@domain.com

*

*