Re: ORA-01406 fetched column value was truncated
From: ddf <oratune_at_msn.com>
Date: Wed, 15 Apr 2009 09:53:12 -0700 (PDT)
Message-ID: <68d2394a-e07c-46c9-bf5d-d03111b42903_at_r3g2000vbp.googlegroups.com>
On Apr 15, 9:53 am, jodleren <sonn..._at_hot.ee> 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 =
> 'CNCMILL'
>
> 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...
>
> WBR
> Sonnich
Date: Wed, 15 Apr 2009 09:53:12 -0700 (PDT)
Message-ID: <68d2394a-e07c-46c9-bf5d-d03111b42903_at_r3g2000vbp.googlegroups.com>
On Apr 15, 9:53 am, jodleren <sonn..._at_hot.ee> 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 =
> 'CNCMILL'
>
> 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...
>
> WBR
> Sonnich
Nothing in the error message text said to fix anything in the database:
"Cause: In a host language program, a FETCH operation was forced to truncate a character string. "
"In a host language program", meaning C++, Java, Visual Basic, ADA, Pascal, etc. No mention was made of anything in the database generating this error.
It's likely not your SQL that's the cause, it's the program buffer area that's the issue so you need to understand how the language you're using is allocating buffer space and find a way to increase that space to prevent a truncation of data. Possibly your variable declarations aren't large enough. Something in your *program* needs to change.
David Fitzjarrell Received on Wed Apr 15 2009 - 11:53:12 CDT