Re: problem with pl/sql
- From: "Mark D Powell" <Mark.Powell@xxxxxxx>
- Date: 14 Mar 2007 06:15:33 -0700
On Mar 13, 11:25 am, DA Morgan <damor...@xxxxxxxxx> 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...@xxxxxxxxxxxxxxxx
(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.
pro* language or being passed through via ODBC.From the error messages I suspect that this is imbedded pl/sql from a
HTH -- Mark D Powell --
.
- References:
- problem with pl/sql
- From: news.atom.pl
- Re: problem with pl/sql
- From: DA Morgan
- problem with pl/sql
- Prev by Date: Re: Subtracting from a set of rows/columns
- Next by Date: too many cursors open
- Previous by thread: Re: problem with pl/sql
- Next by thread: Re: problem with pl/sql
- Index(es):
Relevant Pages
|
