Driver script to run a series of scripts (sql, sqlldr or otherwise) within oracle sqlplus

sql-batch.sql

-- cross platform! Works on unix and windows. Notice ability to run host programs?!

accept _usr  prompt 'UserName: (app) ' default 'app'
accept _pwd  prompt 'Password: (&_usr) ' default &_usr hide
accept _tns  prompt 'TNSalias: (SUE2DEV) ' default 'SUE2DEV'

whenever sqlerror exit
connect &_usr/&_pwd@&_tns
whenever sqlerror continue

-- your SQL and OS scripts here
@@script1.sql
@@script2.sql
host sqlldr &_usr/&_pwd@&_tns control=script3.ctl

undefine _usr _pwd _tns