Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: ORA-00932 inconsistant datatypes
Steffi Kollenz wrote:
> 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/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan_at_x.washington.edu (replace 'x' with a 'u' to reply)Received on Thu Oct 09 2003 - 12:02:32 CDT