Page 1 of 1
OCI has fetched truncated data
Posted: Mon Jan 03, 2005 4:51 am
by wmazzei
Does anyone know what this message means? I get this as a warning when I fetch data from a Siebel table.
Posted: Mon Jan 03, 2005 8:03 am
by kcbland
You have retrieved data in a column that exceeded the specified metadata.
Posted: Mon Jan 03, 2005 8:46 am
by chulett
Search this forum for your entire message and you'll turn up several discussions on the topic. As Ken mentions, you've specified at least one of your fields as being 'too small' in the OCI stage metadata, and OCI had to 'truncate' it to bring it back.
Now, this can be a field declared as a NUMBER in Oracle. Not NUMBER(xx) but NUMBER with no precision. Setting the display size to the default of 38 can cause the problem and upping it to 40 generally fixes it. You can also encounter the problem when sourcing LONG fields.
Anything like that going on?
Posted: Tue Jan 04, 2005 1:45 am
by wmazzei
Many thanks!!! In my case, I changed my varchar(250) to varchar(300). Now it is working.