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: problem with pl/sql

Re: problem with pl/sql

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 13 Mar 2007 08:25:02 -0700
Message-ID: <1173799502.138588@bubbleator.drizzle.com>


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 engine http://tahiti.oracle.com and read the docs. Go to Morgan's Library at www.psoug.org and 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
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Tue Mar 13 2007 - 10:25:02 CDT

Original text of this message

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