Home » Infrastructure » Unix » Ora-00904 Error
Ora-00904 Error [message #97276] Tue, 19 February 2002 09:10 Go to next message
Nicholle
Messages: 1
Registered: February 2002
Junior Member
Hi

I am hoping you could assist me

I am developing an interface to query a database of lease owners. So Soundex comes in handy in cases where misspelt surnames would mean the non-retrieval of records.

The problem I am having is on applying the SQL statement to the database

"select surname from leases where SOUNDEX(surname) = SOUNDEX('Smith')"

It is telling me ORA-00904 Invalid Column Name.

By any chance would one have to create a new field to hold the soundex values generated from by the surname field in the database or is it enough to have just the one on one comparison of SOUNDEX values and where there is a match pull that record. I am developing my application in VB6, using ADO, connected to an Oracle database.

I have used other SQL queries with the same column and they worked but just on applying the SOUNDEX function I get this error. Do you have any thoughts on what it may be.

Thanks
Nicholle
Re: Ora-00904 Error [message #97303 is a reply to message #97276] Wed, 27 February 2002 14:24 Go to previous message
Venkat
Messages: 110
Registered: February 2001
Senior Member
Nicholle,
It is working fine. I've got the error message like
ORA-00904: invalid column name
when I gave it in like soundex("op35sqm") double quotes.

SQL> select testlocation from testwip where soundex(testlocation) = soundex('op35sqm');

TESTLOCATI
----------
oP35SQM

SQL>

Thanks
Jothi
Previous Topic: Re: ORA-12154 TNS unable to connect to destination..
Next Topic: Re: oracle client installation for linux
Goto Forum:
  


Current Time: Wed Sep 23 12:19:55 CDT 2020