About

How to debug a sqlplus script:

• See SQL Plus - Show (System Variable) Command
• To debug, “set pause on” put a pause after all command

set pause on

• To debug, “set echo on”

set echo on

• To debug, “set feedback on”

set feedback on

• verify

set verify on