Re: LONG data type

I hate to break the news to you, but you can't do a search on a LONG data type in Oracle. That's bad news if you've converted a memo field from Access to a LONG field in Oracle and now you're in a corner.

If you want to create a second column or table that holds the stripped down text-only of the LONG field, you can do a search on that. -Murf

In article <3a49d03e_at_ns.baltros.ru>,
  "Vasily Golikov" <vvg_at_baltros.ru> wrote:
> There is a table that has a field of the LONG type. I need check if a
 record
> contains some sample data. How can one do search in LONG data type?
> I tried to obtain LONG field from a cursor but failed. It was wrong
 way
> because some fields contained data with the size more then 32k. (32k
 the
> size of PL/SQL LONG type variable).
>
> Best regards
> Vasily Golikov
>
>

Sent via Deja.com
http://www.deja.com/ Received on Wed Dec 27 2000 - 15:30:48 CST