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 17:24:17 +0200 (CEST)
Message-ID: <22366.213.34.28.241.1081524257.squirrel@webmail.xs4all.nl>


David,

Would it be logical if Informatica fetched the data in some variables? How can it display the selected values otherwise? So, there is a problem.

I do not know Informatica. Does it have its own 'repository', which describes the datamodel of your database? Did you need to load informatica with your datamodel? Did some columns gain some length, provided by an evil developer, after this initial load, leaving informatica ignorant about the change?

If not, you might have hit a bug in Informatica, otherwise this is misconfiguration in informatica. Most likely it is not a bug in Oracle: It is just an informational message telling you that not all retrieved data fits into a variable.Informatica _should_ have a proper error_handler on this.

Regards, Carel-Jan

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

> It is actualy just a select statement. If I run the statement alone, it
> does not error, but when run through Informatica, it generates error.
>
> SELECT S_ASGN_GRP.PR_POSTN_ID AS PR_POSTN_ID, UPPER(ITEM_COUNTRY.LO_CHAR1)
> AS COUNTRY, ITEM_ZIPCODE.LO_CHAR1 AS LO_ZIPCODE FROM
> S_ASGN_GRP,
> S_ASGN_RULE RULE_ZIPCODE,
> S_ASGN_RULE RULE_COUNTRY,
> S_ASGN_RULE_ITEM ITEM_ZIPCODE,
> S_ASGN_RULE_ITEM ITEM_COUNTRY
> WHERE
> ITEM_ZIPCODE.ASGN_RULE_ID = RULE_ZIPCODE.ROW_ID AND
> RULE_ZIPCODE.ITEM_TYPE_NAME = 'Account Zip Code' AND
> RULE_ZIPCODE.ASGN_GRP_ID = RULE_COUNTRY.ASGN_GRP_ID AND
> RULE_COUNTRY.ITEM_TYPE_NAME = 'Account Country' AND
> RULE_COUNTRY.ROW_ID = ITEM_COUNTRY.ASGN_RULE_ID AND
> RULE_ZIPCODE.ASGN_GRP_ID = S_ASGN_GRP.ROW_ID AND
> S_ASGN_GRP.NAME LIKE 'ECC%' ORDER BY COUNTRY,LO_ZIPCODE,PR_POSTN_ID
> Function: Fetch
> Error: ORA-01406: fetched column value was truncated
>
> --
> - David Life is what happens while waiting
> or planning for the future.
>> 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
>> -----------------------------------------------------------------
>
> ----------------------------------------------------------------
> 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:21:25 CDT

Original text of this message

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