Passing from Unix to PLSQL using bind variables

. $ENV_FILE

echo “Started test.ksh `date +%D-%T`”

V1=1;

V3=One;

$ORACLE_HOME/bin/sqlplus pvm/pvm<set serveroutput on;

variable pvm1 number;

exec :pvm1:=$V1;

variable pvm2 varchar2(30);

exec :pvm2:=’`date +%D-%T`’;

variable pvm3 varchar2(20);

exec :pvm3:=’$V3′;

exec prod_display(:pvm1, to_date(:pvm2, ‘MM/DD/RR-HH24:MI:SS’), :pvm3);

EOF

echo “Ended at `date +%D-%T`”