Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Terminating a PL/SQL Procedure

822739Jan 18 2011 — edited Jan 18 2011
I am contemplating asking my DBA to end my PL/SQL procedure that has been running for 4+ hours and I have no idea why this time it is taking this long. It has ran fine in our DEVL and TEST systems.

My Question is: If I ask the DBA to kill the process will it recognise the SAVEPOINT and ROLLBACK to it if my code looks like the following:
BEGIN

     SAVEPOINT BEFORE_EXEMPTIONS;
     
     FOR REC_POPSEL IN C_POPSEL LOOP

        [EXECUTE CODE HERE]

     END LOOP;
     
     GB_COMMON.P_COMMIT;

EXCEPTION
  WHEN OTHERS THEN
    ROLLBACK TO BEFORE_EXEMPTIONS;
This post has been answered by William Robertson on Jan 18 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 15 2011
Added on Jan 18 2011
1 comment
234 views