David - I don 't use Informatica. Does it maintain its own data dictionary?
Is it possible the Informatica dictionary is out of sync with the Oracle
dictionary?
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams@(protected)
-- --Original Message-- --
From: oracle-l-bounce@(protected)
[mailto:oracle-l-bounce@(protected)]On Behalf Of thump604@(protected)
Sent: Friday, April 09, 2004 10:00 AM
To: oracle-l@(protected)
Subject: Re: ORA-01406 (See ORA-01406.ora-code.com): fetched column value was truncated
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 (See ORA-01406.ora-code.com): 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@(protected)
> > 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@(protected)
> 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@(protected)
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@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
