Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error on declaring variable

894559Jul 13 2012 — edited Jul 13 2012
Hi, I'm trying to run the following pl/sql query in SQL Developer 2.1.0.63:
DECLARE something NUMBER;
I get the error:

Error starting at line 1 in command:
DECLARE something NUMBER;
Error report:
ORA-06550: line 1, column 25:
PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:

begin function pragma procedure subtype type <an identifier>
<a double-quoted delimited-identifier> current cursor delete
exists prior
06550. 00000 - "line %s, column %s:\n%s"
*Cause: Usually a PL/SQL compilation error.
*Action:

What's wrong with what I'm doing?

-Eric
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 10 2012
Added on Jul 13 2012
10 comments
4,381 views