Re: problem with pl/sql
- From: DA Morgan <damorgan@xxxxxxxxx>
- Date: Tue, 13 Mar 2007 08:25:02 -0700
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@xxxxxxxxxxxxxxxx
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
.
- Follow-Ups:
- Re: problem with pl/sql
- From: gazzag
- Re: problem with pl/sql
- From: Mark D Powell
- Re: problem with pl/sql
- References:
- problem with pl/sql
- From: news.atom.pl
- problem with pl/sql
- Prev by Date: problem with pl/sql
- Next by Date: Re: Disable trigger by partition
- Previous by thread: problem with pl/sql
- Next by thread: Re: problem with pl/sql
- Index(es):
Relevant Pages
|
