[thesite] meta description
Dean Mah
dmah at shaw.ca
Mon Jan 21 21:06:05 CST 2002
Correct. You can't do functions on LONG datatypes. One of the many
restrictions.
Dean
Warden, Matt writes:
> >can you force it to a case-insensitive search by wrapping the column
> >reference with a Lower() function? for example:
> >
> >DBMS_LOB.INSTR(Lower(column), '#LCase(search_string)#') <> 0
>
> no, i tried that a few days ago when i was playing around with
> dbms_lob on the test db. it gives an invalid type message of some
> sort. I guess you can't use LOWER() on that type of field.
More information about the thesite
mailing list