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 -> Re: Oracle lite PL/SQL Help

Re: Oracle lite PL/SQL Help

From: Finn Ellebaek Nielsen <fen_at_changegroup.dk>
Date: Sat, 12 Jun 1999 00:19:48 +0100
Message-ID: <7js23s$2va$1@news.inet.tele.dk>


Chris <coopercj_at_cadvision.com> wrote in message news:376137D9.33491A6_at_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?
>
>

Oracle Lite doesn't support PL/SQL...

HTH. Finn Received on Fri Jun 11 1999 - 18:19:48 CDT

Original text of this message

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