There is a whole bunch of things you can't do with LONG datatypes; one
of them is referencing them in a WHERE clause, and that is what you try
do do

That is the reason Oracle urges you to no longer use them; instead use
LOB's

Hans


-----Original Message-----
From: satheesh
[mailto:oracledba-ezmlmshield-x71103454.[Email address protected]
Sent: woensdag 6 september 2006 10:02
To: LazyDBA Discussion
Subject: Like Operator against a LONG data Type


Hi DBA's

In a SQL statement when i try to use the like Operator against a
column
of LONG data type i get the error

3DP05891> select * from xmit_msg_que_w where to_char(QUE_MSG_T) like
'%010405890%';
select * from xmit_msg_que_w where to_char(QUE_MSG_T) like '%010405890%'
*
ERROR at line 1:
ORA-00932: inconsistent datatypes: expected CHAR got LONG

Could You please help me on the issue. I want to search for a pattern
against a column defined as LONG data type.

Thanks In Advance
Satheesh M
=====-----=====-----=====
Notice: The information contained in this e-mail
message and/or attachments to it may contain
confidential or privileged information. If you are
not the intended recipient, any dissemination, use,
review, distribution, printing or copying of the
information contained in this e-mail message
and/or attachments to it are strictly prohibited. If
you have received this communication in error,
please notify us by reply e-mail or telephone and
immediately and permanently delete the message
and any attachments. Thank you




---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
-----------------------------------------------------------------
ATTENTION:
The information in this electronic mail message is private and
confidential, and only intended for the addressee. Should you
receive this message by mistake, you are hereby notified that
any disclosure, reproduction, distribution or use of this
message is strictly prohibited. Please inform the sender by
reply transmission and delete the message without copying or
opening it.

Messages and attachments are scanned for all viruses known.
If this message contains password-protected attachments, the
files have NOT been scanned for viruses by the ING mail domain.
Always scan attachments before opening them.
-----------------------------------------------------------------


Oracle LazyDBA home page