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