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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: ORA-01406: fetched column value was truncated

Re: ORA-01406: fetched column value was truncated

From: Carel-Jan Engel <cjpengel.dbalert_at_xs4all.nl>
Date: Fri, 9 Apr 2004 16:46:12 +0200 (CEST)
Message-ID: <16076.213.34.28.241.1081521972.squirrel@webmail.xs4all.nl>


When a receiving vaiable is defined shorter than the actual column length, the column gets truncated during the fetch. So, you probably perform some 'fetch into ....' or 'select .... into ...', and should define a larger variable to store all of the fetched data.

Regards, Carel-Jan

===
If you think education is expensive, try ignorance. (Derek Bok) ===

> Can anyone provide an explanation on what this errror means and why we
> would get it on a select statment once, but not again.
> I found very little info on MEtalink.
> Thanks!
>
> --
> - David
> Life is what happens while waiting
> or planning for the future.
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>



Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Fri Apr 09 2004 - 10:40:18 CDT

Original text of this message

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