This content has been marked as final. Show 2 replies
As you didn't post the code and we don't know your procedure, please answer your own question.
If there are 1 or more COMMITs in the procedure, the answer is NO.
Senior Oracle DBA
It really depends what your procedure is doing.
e.g. if it's a batch process that's driven from a queue, there's a chance you'll be able to re-run it, and it will continue where it failed.
But it's impossible to say for sure without knowing exactly what your code is doing.