Re: problem with pl/sql

On Mar 13, 11:25 am, 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 -

I would say this is a tool/language/interface problem rather than a pl/ sql language problem since the posted code is perfectly valid and runs successfully on my 9.2.0.6 version via SQLPlus

UT1 > set echo on
UT1 > get t22
  1 declare
  2 a number := 2;
  3 begin
  4 a := a + 1;
  5* end;
UT1 > /

PL/SQL procedure successfully completed.

UT1 > run
  1 declare
  2 a number := 2;
  3 begin
  4 a := a + 1;
  5* end;

PL/SQL procedure successfully completed.

>From the error messages I suspect that this is imbedded pl/sql from a
pro* language or being passed through via ODBC.

HTH -- Mark D Powell -- Received on Wed Mar 14 2007 - 08:15:33 CDT