Re: ORA-01406: fetched column value was truncated
- From: "Carel-Jan Engel" <cjpengel.dbalert@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 9 Apr 2004 17:24:17 +0200 (CEST)
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@xxxxxxxxxxxxx
>> > put 'unsubscribe' in the subject line.
>> > --
>> > Archives are at //www.freelists.org/archives/oracle-l/
>
>> > FAQ is at //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@xxxxxxxxxxxxx
>> put 'unsubscribe' in the subject line.
>> --
>> Archives are at //www.freelists.org/archives/oracle-l/
>> FAQ is at //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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
