Re: Oracle lite PL/SQL Help

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