welcome to http://www.startdays.com
welcome to http://www.ijachouf.com
welcome to http://www.swtools.biz
welcome to http://www.decoderhd.com
How to Make PL/SQL Updates Restartable
Oracle Tips by Burleson Consulting
June 21, 2011
Question: I want my PL/SQL program to be restartable, such that if
there is an abort from a non-zero return code, the PL/SQL program will
restart from the last commit checkpoint.
What is the best way to make a PL/SQL batch update job restartable?
Answer: Obviously, the best way to make PL/SQL DML jobs restartable is
to never use a commit, and re-run the whole job.
---------------------------------------------------------------
---------------------------------------------------------------
---------------------------------------------------------------
0 Commentaires