Then you will have to use a piecewise retrieval until you get to the end of
the long. (keeping track of how many pieces and how large each one is - sum
them up - to find the length of a long.)
Jim
--
Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
with family. Remove the negative part, keep the minus sign. You can figure
it out.
"Trevor Bourget" <tbourget-REMOVE-_at_racltd.com> wrote in message
news:v5kf0kt7fsgd55_at_corp.supernews.com...
> I realise that is it would be much easier if a blob field was used,
however,
> the database is already in place.
>
> "Jim Kennedy" <kennedy-down_with_spammers_at_attbi.com> wrote in message
> news:yxG5a.213933$Ec4.216241_at_rwcrnsc52.ops.asp.att.net...
> > You don't you use a clob. Longs are deprecated. Easy if you use a clob.
> > Jim
> >
> > --
> > Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
> > with family. Remove the negative part, keep the minus sign. You can
> figure
> > it out.
> > "Trevor Bourget" <tbourget-REMOVE-_at_racltd.com> wrote in message
> > news:v5devv9iiumm29_at_corp.supernews.com...
> > > Sorry. I am in Oracle 9i.
> > >
> > > thanks again.
> > >
> > > "Trevor Bourget" <tbourget-REMOVE-_at_racltd.com> wrote in message
> > > news:v5deunae0dn218_at_corp.supernews.com...
> > > > For the life of me I cant seem to remember or find how to get the
> Length
> > > of
> > > > a Long datatype.
> > > >
> > > > Any help is most welcome.
> > > >
> > > > Thanks in advance.
> > > >
> > > > Trevor
> > > >
> > > >
> > >
> > >
> >
> >
>
>
Received on Mon Feb 24 2003 - 21:53:41 CST
