I am trying to close of multiple users in an Oracle database. Each users has records in multiple tables what I need to do is use a script that call each SQL seperately passing either CLI arguments or gathered arguments from the users during run time.
## Accept variable(s) from the command line
while test $1
do
set emp_id = $1
echo "Enter Expiry Date: \c"
read exp_dt
echo "Enter Effective Date: \c"
read eff_dt
$HOME/sql_files/close_c.ksh $exp_dt $emp_id $eff_dt
shift
done
Any ideas will be appreciated.