Re: Oracle V8 : ORA 904 but column exists ???!!!

Once, on a version long gone... ( 5.3 maybe lol.. I'm old.)

We got some tool or other that created table names in lower case in the schema
somehow. you could query them (Select * from tab; ) in SQL Plus and see them
in lower case, but you could not select from them because the parsed sql would be
in upper case.

no idea if this is remotely what you're talking about.. just reminded me of it.

Randy

kru wrote:

> Hi everybody,
>
> some of our SQL code throws ORA 904, invalid column name, though
> the column exists. Amazing enough, this error message will not appear
> in all of our applications we usee to execute that statement:
>
> - sqlplus
> - WinSQL
> - ODBC
>
> The old release of Oracle V7.3.4 does not through any error.
> Anyone 've got an idea ?
>
> CCK
Received on Tue Apr 25 2000 - 00:00:00 CDT