Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> 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
![]() |
![]() |