Re: problem with pl/sql

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Fri, 16 Mar 2007 17:13:33 +0100
Message-ID: <45fac22b$0$7534$426a74cc@news.free.fr>

"gazzag" <gareth_at_jamms.org> a écrit dans le message de news: 1174050229.292335.286620_at_n59g2000hsh.googlegroups.com...
| 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

|

The important part here is "most recently executed". In the case of the OP the PL/SQL block was never executed when it typed RUN, it was currently writing it.

Regards
Michel Received on Fri Mar 16 2007 - 11:13:33 CDT