Re: PL/SQL Problem

From: Robert Goold <robert_at_rgoold.spamnot.freeserve.co.uk>
Date: Fri, 11 Feb 2000 22:43:30 GMT
Message-ID: <38a48fef.8806344@news.compuserve.com>

Your account probably has a restriction set in the table PRODUCT_USER_PROFILE which is preventing you from using DECLARE. The DBA can selectively disable most SQL*Plus commands in this way. The appropriate rows need either to be removed or have char_value changed for the command to be enabled.

Robert

On Wed, 2 Feb 2000 14:03:51 -0500, "Greg Burns" <greg.m.burns_at_usace.army.mil> wrote:

>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 Fri Feb 11 2000 - 16:43:30 CST