Have you tried the Microsoft ODBC for Oracle driver?
I've noticed in various occasions it works better than the Oracle-supplied
one
--
Lorenzo J. Simaika
Systems Engineer
http://simaika1.interfree.it
Connor McDonald <connor_mcdonald_at_yahoo.com> wrote in article
<3C9901EE.5945_at_yahoo.com>...
> Wesley wrote:
> >
> > I apologize if this has been asked and answered, but I didn't see it
when I
> > scanned the newsgroup.
> >
> > I have a web application that uses the Oracle8 ODBC driver to retrieve
lots
> > of data. However, one of the columns is truncating terribly, in fact,
only
> > the first byte is coming across. It's datatype is LONG. I have done
some
> > searching on the net and found that Oracle's ODBC driver doesn't deal
with
> > LONG data types. Certainly this is a common problem. Do any of you
have
> > any suggestions for retrieving this type of data?
> >
> > Thanks,
> > Wesley
>
> You can code up a PL/SQL routine to return the first 32k characters (or
> 4k if you plan on doing it from SQL).
>
> hth
> connor
> --
> ==============================
> Connor McDonald
>
> http://www.oracledba.co.uk
>
> "Some days you're the pigeon, some days you're the statue..."
>
Received on Fri Mar 22 2002 - 07:22:26 CST
