Re: LONG data type

From: res0642b <res0642b_at_gte.net>
Date: Fri, 05 Jan 2001 03:19:59 GMT
Message-ID: <y3b56.1048$5X2.403130@paloalto-snr1.gtei.net>

I would bet that you could write a pl/sql procedure that would select that long into a series of varchar variables, and you could search on those....

messy messy messy, but hey, longs are messy business.

hth,

Jack
Senior DBA @ www.xol.com

"Vasily Golikov" <vvg_at_baltros.ru> wrote in message news:3a49d03e_at_ns.baltros.ru...
> 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
>
>
>
>
>
Received on Thu Jan 04 2001 - 21:19:59 CST