Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> ORA-00932 inconsistant datatypes

ORA-00932 inconsistant datatypes

From: Steffi Kollenz <stephanie_at_kollenz.de>
Date: Thu, 09 Oct 2003 18:09:56 +0200
Message-ID: <bm40vc$nn3$1@online.de> 





Hi,


i try to execute the following select statement:
"select URN from DocStore where VALUE like '%test%';"
The table: column  URN is type VARCHAR2, column VALUE is type LONG.
I get the error ora-00932 inconsistant datatypes. Can anybody tell me 
how to make such a select statement on columns of type long?
Thanks


Steffi
Received on Thu Oct 09 2003 - 11:09:56 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US