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;