Re: ORA-00904: invalid column name.

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 01 Sep 1998 21:24:10 +0200
Message-ID: <35EC49D9.A98C1AA1@sybrandb.demon.nl>

Hi Thomas,

Most likely the user running this statement doesn't have EXECUTE privilege and/or a synonym for this function

Hth,

Sybrand Bakker, Oracle DBA

Thomas Læhren wrote:

> Hi!
>
> When I run this sql-statement (Sql*Plus):
>
> select reverse(user) from dual
>
> I'm getting a ORA-00904 error.
>
> I think it's the reverse function who fails......
>
> Can anybody help me ?
>
> I'm running:
> Oracle7 Server Release 7.3.2.2.0 - Production Release
> PL/SQL Release 2.3.2.2.0 - Production
> CORE Version 3.5.2.0.0 - Production
> TNS for 32-bit Windows: Version 2.3.2.1.0 - Production
> NLSRTL Version 3.2.2.0.0 - Production
>
> on a MS NT Server 4.0 SP3
>
> Best Regards, Thomas
Received on Tue Sep 01 1998 - 14:24:10 CDT