From oracle-l-bounce@freelists.org Fri Apr 9 10:21:25 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i39FLOu00517 for ; Fri, 9 Apr 2004 10:21:24 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i39FLOo00505 for ; Fri, 9 Apr 2004 10:21:24 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8BC28634850; Fri, 9 Apr 2004 10:15:48 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 19306-78; Fri, 9 Apr 2004 10:15:48 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B4D54634578; Fri, 9 Apr 2004 10:15:47 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 09 Apr 2004 10:14:38 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id EE6436343E8 for ; Fri, 9 Apr 2004 10:14:37 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 19306-60 for ; Fri, 9 Apr 2004 10:14:37 -0500 (EST) Received: from smtp-out5.xs4all.nl (smtp-out5.xs4all.nl [194.109.24.6]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 25FBE634512 for ; Fri, 9 Apr 2004 10:14:37 -0500 (EST) Received: from webmail.xs4all.nl (webmail4.xs4all.nl [194.109.22.164]) by smtp-out5.xs4all.nl (8.12.10/8.12.10) with SMTP id i39FOHk2014788 for ; Fri, 9 Apr 2004 17:24:17 +0200 (CEST) Received: from 213.34.28.241 (SquirrelMail authenticated user careljan) by webmail.xs4all.nl with HTTP; Fri, 9 Apr 2004 17:24:17 +0200 (CEST) Message-ID: <22366.213.34.28.241.1081524257.squirrel@webmail.xs4all.nl> In-Reply-To: <040920041500.6488.4076BA8C000650FB000019582200737478FFCBCFC98F928A97@ comcast.net> References: <040920041500.6488.4076BA8C000650FB000019582200737478FFCBCFC98F928A97@comcast.net> Date: Fri, 9 Apr 2004 17:24:17 +0200 (CEST) Subject: Re: ORA-01406: fetched column value was truncated From: "Carel-Jan Engel" To: oracle-l@freelists.org User-Agent: SquirrelMail/1.4.2 [CVS] MIME-Version: 1.0 Content-type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 2820 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: cjpengel.dbalert@xs4all.nl Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org 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@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@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@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@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 -----------------------------------------------------------------