I used to write PL/SQL programs in oracle 9i.Since windows 7 doesnt support it, switched to oracle 10g express edition. All my SQL programs are alright. But I cant put mutiple queries on a single run though. Like insert into many rows. But PL SQL programs are going crazy. Too many errors.Please help me figure out what is wrong here. How to convert 9i programs to 10g
declare
pi constant number(5,2):=3.14;
radius number(5);
area number (14,2);
circumference number(14,2);
l_limit number(2);
u_limit number(3);
begin
l_limit:=&l_limit;
u_limit:=&u_limit;
radius:=l_limit;
while radius<=u_limit
loop
area :=pi*radius*radius;
circumference :=2*pi*radius;
insert into area VALUES(radius,area,circumference);
radius:=radius+1;
end loop;
end;
/
create table area(radius number(5) primary key ,area number (14,2), circumference number(14,2));