Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Oracle lite PL/SQL Help

Oracle lite PL/SQL Help

From: Chris <coopercj_at_cadvision.com>
Date: Fri, 11 Jun 1999 10:22:50 -0600
Message-ID: <376137D9.33491A6@cadvision.com>


 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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US