Re: problem with pl/sql

On 13 Mar, 15:25, DA Morgan <damor..._at_psoug.org> wrote:
> news.atom.pl wrote:
> > hello, i'm new in pl/sql i have problem with basic command like:
>
> > declare
> > a number := 2;
> > begin
> > a := a + 1;
> > end;
> > .
> > run;
>
> > becouse database show me:
>
> > Executing:
>
> > end
>
> > ORA-00900: invalid SQL statement
> > [Error Code: 900]
> > [SQL State: 42000]
>
> > Executing:
>
> > .
> > run
>
> > ORA-00900: invalid SQL statement
> > [Error Code: 900]
> > [SQL State: 42000]
>
> > what is wrong, could enybody explain where is problem.
>
> > thanks in advantige.
> > sw
>
> Oracle is NOT SQL Server. Where did you get the syntax
>
> > .
> > run;
>
> It sure wasn't from any Oracle related document. Get a copy
> of some Oracle books and read them. Visit Oracle's search enginehttp://tahiti.oracle.comand read the docs. Go to Morgan's
> Library atwww.psoug.organd look at the demos.
>
> SQL*Plus: Release 10.2.0.2.0 - Production on Tue Mar 13 08:22:40 2007
>
> Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
>
> Connected to:
> Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
> With the Partitioning, OLAP and Data Mining options
>
> SQL> declare
> 2 a number := 2;
> 3 begin
> 4 a := a + 1;
> 5 end;
> 6 /
>
> PL/SQL procedure successfully completed.
>
> SQL>
>
> Every time you try to pretend Oracle is some other product is time wasted.
> --
> Daniel A. Morgan
> University of Washington
> damor..._at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org- Hide quoted text -
>
> - Show quoted text -

A new one on me too, however:

SQL> help run

 RUN
 ---

 Lists and executes the most recently executed SQL command  or PL/SQL block which is stored in the SQL buffer.

 R[UN]

HTH -g Received on Fri Mar 16 2007 - 08:03:49 CDT