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: Probems with LONG datatypes and DBD

Re: Probems with LONG datatypes and DBD

From: Lisa Harvey <mgharvey_at_bigpond.com>
Date: Thu, 29 Apr 1999 14:15:21 GMT
Message-ID: <37286850.8659275@news.bigpond.com>


The later versions of DBD-Oracle report an error by default if a long value is truncated during a fetch (only the first 80 bytes are fetched by default). There is DBD property to disable this: I think it is something like long_trunc_ok.
ie. to allow truncation of longs:
$db->long_trunc_ok = 1;

You should be able to find details in the DBD-Oracle documentation.

Regards,
Michael.

On Thu, 29 Apr 1999 13:47:01 +0100, "Paul Davies" <cobalt_at_dircon.co.uk> wrote:

>I'm using the latest version of Oracle on Linux with DBD.
>
>When I try to retrieve the value of a column of type LONG using a simple
>SELECT statement I come across the following error:
>
>A Truncation or null fetch error occurred....
>
>Can someone help me understand the problem?
>
>They query works just fine in SQL Plus
>
Received on Thu Apr 29 1999 - 09:15:21 CDT

Original text of this message

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