Hi

I have the following shell script

#####################################
#!/bin/sh

user =${1}
pass =${2}
sid =${3}
colmatch =${4}
deltable =${5}
childtbl =${6}
childcol =${7}
parenttbl =${8}
parentcol =${9}
part =${10}



${ORACLE_HOME}/bin/sqlplus ${user}@${sid}/${pass} << __eof__
set head off;
commit;
set transaction use rollback segment rei_data_load;
declare
acc_num ${deltable}.${colmatch}%type;
cursor c1 is
select ${colmatch} from ${deltable};
begin
open c1;
loop
fetch c1 into acc_num ;
exit when c1%notfound;
Delete from ${childtbl} partition ${part}
where ${childcol} = acc_num;
Delete from ${parenttbl} partition ${part}
where ${parentcol} = acc_num;
end loop;
close c1;
end;

#######################################

How do I run it from unix and test it out. The program name is del.sh

Please advise

Badrinath