ORA-00932 inconsistant datatypes

#1

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

#2

Steffi Kollenz wrote:

Quote:

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

You can't. At least not in PL/SQL and not in one step.

Go to http://asktom.oracle.com and look up LONG to CLOB.

--
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
http://www.outreach.washington.edu/e...oa/aoa_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

ORA-00932 inconsistant datatypes

comp.databases.oracle.misc comp.databases.oracle.misc

ORA-00932 inconsistant datatypes - 10-09-2003 , 11:09 AM

Re: ORA-00932 inconsistant datatypes - 10-09-2003 , 12:02 PM