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.

Dear,

Could you refrase your question cause I'm not sure what you want to do. Probably I can help.