Click to See Complete Forum and Search --> : help ?


puneet
03-30-2001, 02:00 PM
Please let me know what is wrong with this

declare
a number ;
b number ;
x number ;
y number ;
d date ;
z date ;
begin
loop <<A>>
a = 1;
b := a+1;
select shrfnbr into x from puneet_temp where serial = a;
select timestamp into d from puneet_temp where serial = a;
select shrfnbr into y from puneet_temp where serial = b;
loop <<B>>
select trunc(shrstmp) into z from shopper where shrfnbr = x;
if
z <> d
then
dbms_output.put_line ( x||' ' || z ) ;
x:= x+1;
end if;
exit when x=y;
end loop B ;
a:=a+1;
exit when a = 200;
end loop A ;
end;

akkerend
04-01-2001, 05:58 PM
1. Remove the <> after LOOP
2. Use : in a := 1 in first loop.