-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|