OCI has fetched truncated data

wmazzei · Post by **wmazzei** » Mon Jan 03, 2005 4:51 am

Does anyone know what this message means? I get this as a warning when I fetch data from a Siebel table.

kcbland · Post by **kcbland** » Mon Jan 03, 2005 8:03 am

You have retrieved data in a column that exceeded the specified metadata.

chulett · Post by **chulett** » Mon Jan 03, 2005 8:46 am

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?

wmazzei · Post by **wmazzei** » Tue Jan 04, 2005 1:45 am

Many thanks!!! In my case, I changed my varchar(250) to varchar(300). Now it is working.