Shell Programming and Scripting

#!/bin/ksh[/FONT][/SIZE][/COLOR]
echo "please enter case:"
read v_case_nbr
echo "the case number entered is $v_case_nbr"
sqlplus wmtst/wmtst@wmtest <<EOF
@ test.sql $ v_case_nbr
exit;
EOF

 SET SERVERoutput on;
declare 
v_case_nbr varchar(400):='&Enter_Case_nbr';
c_stat_code case_hdr.stat_code%type;

 cursor c1 is select ch.stat_code into c_stat_code from case_hdr ch  where ch.case_nbr=v_case_nbr;
  
 
begin
open c1;
LOOP
FETCH c1 into c_stat_code;
EXIT when c1%notfound;
If (c_stat_code = '50')
then
update case_hdr ch
set ch.stat_code='30',
ch.user_id = 'PILLAREM',
ch.mod_date_time = sysdate 
where ch.case_nbr = v_case_nbr;
dbms_output.put_line('Case_hdr:Case updated To putaway status ');
end if;
 end loop;
 close c1;
 end;
 /

 #!/bin/sh
echo "please enter case:"
read v_case_nbr
echo "the case number entered is $v_case_nbr"
sqlplus wmtst/wmtst@wmtest <<EOF
@ test.sql ,v_case_nbr
 exit;
EOF

@ test.sql $v_case_nbr

#!/bin/sh
echo "please enter case:"
read v_case_nbr
echo "the case number entered is $v_case_nbr"
sqlplus wmtst/wmtst@wmtest <<EOF
@ test.sql $v_case_nbr_
 exit;
EOF

declare
 v_case_nbr number;
 
select count(*) from case_hdr where case_nbr=&1;