Re: ORA-01406 fetched column value was truncated

From: jodleren <>
Date: Sun, 19 Apr 2009 23:42:29 -0700 (PDT)
Message-ID: <>

Just to clear up things and fir someone in the future:

The problem was that I was reading from views, where in one there was: field_a/field_b and sometimes field_b would be 0, causing a Division by 0 error.

That resulted in this errors.


On Apr 15, 5:53 pm, jodleren <> wrote:
> Hello
> When reading a double from a table, I get this error:
> ORA-01406 fetched column value was truncated
> The desciption is:
> ORA-01406 fetched column value was truncated
>     Cause: In a host language program, a FETCH operation was forced to
> truncate a character string. The program buffer area for this column
> was not large enough to contain the entire string. The cursor return
> code from the fetch was +3.
>     Action: Increase the column buffer area to hold the largest column
> value or perform other appropriate processing.
> The problem is that it is a working database in 3+ copies, so I cannot
> really go an change things. And I cannot even see where it is wrong,
> except that it is a numver of places.
> The error occures when
> select workingtime (double, size 15) from sdfgsdfgf where department =
> When selecting other departments, the error might be there, it might
> not. The error might also come when scrolling data.
> I would apriciate to fix my SQL, not the database.... as I have no
> idea what might happen elsewhere if I do so...
> WBRSonnich
Received on Mon Apr 20 2009 - 01:42:29 CDT

Original text of this message