Re: LONG data type

Jack,
The problem is that I can not get even a part of a LONG value in a select statement. The functions such substr, etc. do not work at all. So, would you be so kind to get an advice how can I select long "into a series of varchar variables".

"> 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 Tue Jan 09 2001 - 04:16:14 CST