What is the difference between “Jump” and “Ignore All” (and “Ignore” and “Ignore this Error”)? when executing via “TOAD Script Runner”?
“Jump” should point to line where error occurred.
“Ignore this Error” mean that current statement error should be ignored and skip execution to another statement.
“Ignore All” means skip to another statement whenever error occur.
What you should choose depend how your script was written.
Example:
If your first statement is create table and has error then there is no sense to skip to next statement which create index on that table (not created because it has error in previous statement).
If you have drop table which is followed by create table statement, then drop may be Ignored because this is for case if table exists.
Hope this helps
Cheers,
Damir
Just to clarify, let me ask how the following script execution would play out for each choice of [Ignore this Error | Ignore All | Jump]:
Example:
Execute script containing these statements:
Stmt1: OK
Stmt2: Error 1 occurs
Stmt3: OK
Stmt4: Error 2 occurs
Stmt5: OK
Stmt6: Error 1 occurs
Stmt7: OK
End
if this is PL/SQL block (between begin and end) then such constructions are called blocks and all statements from block must be valid and there is no way to run separate lines.
If each line is separate statement (like in mine case) then:
statements 1,3,5,7 will be executed in a case ignore or ignore all
Jump choice will move focus to error line and stop execution.
But please show exact code if you are still not sure.
Cheers