Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: LONG data issue

Re: LONG data issue

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Wed, 20 Mar 2002 21:41:02 +0000
Message-ID: <3C9901EE.5945@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 Wed Mar 20 2002 - 15:41:02 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US