Home » RDBMS Server » Server Administration » "ORA-00932: inconsistent datatypes" long field in where clause
"ORA-00932: inconsistent datatypes" long field in where clause [message #371638] Fri, 17 November 2000 11:11 Go to next message
Hans Jürgen Huber
Messages: 1
Registered: November 2000
Junior Member
Hello everybody!
In my Oracle Database are a long field filled with some small Text Phrases. Now i have to search for a phrase like "press". An Ora-00932 comes back! No long fields in a where clause.
Who knows a solution or a workaround?
Many thanks for your support!
Jürgen

select table_interact.last_name, table_interact.phone
from table_rol_contct, table_interact, table_interact_txt
where table_interact_txt.notes like '%Press%'

Report message to a moderator

Re: "ORA-00932: inconsistent datatypes" long field in where clause [message #371688 is a reply to message #371638] Sat, 25 November 2000 19:14 Go to previous message
SQL_Tuner
Messages: 8
Registered: November 2000
Junior Member
Hans, a work around is to write a PL/SQL block that uses the SUBSTR () function against the LONG column to SELECT pieces of the LONG string into a variable. The whole column could be read like this. Then search the pieces, perhaps with an INSTR function.

A pain, but it works.

Regards,
ST

Report message to a moderator

Previous Topic: ADDRESS E-MAIL
Next Topic: Collection to ref cursor
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat May 04 11:47:20 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.