Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Invalid column name ??
Bricklen <bricklen_at_zyahoo.zcomz> wrote:
>Turkbear wrote:
>> Bricklen <bricklen_at_zyahoo.zcomz> wrote:
>>
>>
>>>thomas goodwin wrote:
>>>
>>>> I did a table export from Acess 2002 to Oracle9i.
>>>> When I "Select * from table1" I see all of the variables.
>>>> When I select individual variables ("select var1 from table1")
>>>> I sometimes get a value. For other variables I get
>>>> ORA 00904 Invalid column name.
>>>>
>>>> I am using the exact spelling the the variable name I see in my
>>>> Select * statement.
>>>>
>>>> Any ideas?
>>>>
>>>> thanks, tom g
>>>
>>>Could be caused by a case sensitivity problem. IIRC, Access uses double
>>>quotes around names and preserves the case. Try it that way to see if
>>>that could be the problem, eg
>>>
>>>select "var1" from "table1";
>>>
>>>Or maybe your column names are reserved words? I can't remember whether
>>>or not reserved words trigger that error or not, though.
>>>select * from v$reserved_words;
>>
>>
>> Just an note : Those are Columns not variables...hence the error message referring to Column Name.
>>
>>
>I'm assuming that by variables, he meant column names, but I maybe I
>assumed incorrectly.
I suspect your assumption is correct ( at least I hope so)..
Received on Tue Oct 05 2004 - 11:57:55 CDT