Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: LONG data issue
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 Wed Mar 20 2002 - 15:41:02 CST