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 -> PL/SQL Problem

PL/SQL Problem

From: Greg Burns <greg.m.burns_at_usace.army.mil>
Date: Wed, 2 Feb 2000 14:03:51 -0500
Message-ID: <879uuq$cs3$1@goo.nwd.usace.army.mil>


When I try to define a variable using the "declare" command at the SQL prompt, I receive the following error:

SQL> declare
invalid command: declare
SQL> exit

However, when I log in as another user on the same database instance, I do not get the error. How can I get the first account to recognize declare as a valid command?

Thanks,
Greg Received on Wed Feb 02 2000 - 13:03:51 CST

Original text of this message

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