Oracle lite PL/SQL Help

 I am a beginner, I have taken an Intro course to Oracle. I have installed the trial version of Oracle lite on a lap top. Commands such as Select, Insert ect worked okay for the intro course. Now I am trying Pl commands and there are problems. This simple program will not execute.

create table areas(
radius number(14,2),
area number(14,2)
);

This segment works fine. and the table is created. However, the example in the book I am using has
radius integer(5), on line two. This line will not work.

declare
pi constant number(9,7) := 3.1415926;
radius number(14,2);
area number(14,2);
begin
radius := 3;
area := pi * power(radius, area);
insert into areas values (radius, area); end;
.
SQL>/
declare
*
error at line 1:
OCA-30021: error preparing/executing SQL statement [POL-5228] syntax error

Any suggestions? Received on Fri Jun 11 1999 - 11:22:50 CDT