Devart Forums

It looks like the return data buffer size for numbers may be sized too small when FieldsAsString is true and Unicode is turned on. In some cases I get an "Ora-01406" error and in other cases the returned string seems to be cut short without an error message.

I haven't nailed it down completely yet, but one example is the following script. The query should show '-1', but it will only show '-':
This isn't the only case though. If I have a function that returns a number, if the number is large, the value gets truncated. Please let me know if you need more info and I'll try to make a better test case!

Thanks.

We have increased the field size by one character to hold the sign. The fix will be included in the next ODAC build.

Please provide us an example for a function that returns a number.

Thanks! It looks to me as though the default lengths for a number aren't enough (even adding 1). If you select a really big number like:
The current version will give you:
10000000002000000000300000000040000000

If you expand the return buffer, you'll see that Oracle actually sends the correct result:
100000000020000000003000000000400000000000000000000000000000000000000000000000000

It looks like the existing code assumes that the largest regular number would be 38 digits or so.

In the next build we'll change the field size for NUMBER to 132 because the maximum exponent for NUMBER is 130.

Thanks!