Re: ORA-00904: invalid column name.

Thanks for your suggestion, but I have tried the system user too, with the same result (ORA-00904).

I've heard that the same error occured on the 7.3.2.3.0 (Intel Solaris 2.6) Workgroup server platform.

Is it possible that Oracle 7.3.2.x.x has this kind of bug ?

Thanks!

Sybrand Bakker wrote in message <35EC49D9.A98C1AA1_at_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 Wed Sep 02 1998 - 03:19:11 CDT