I'm using RS 2000 and I'm getting an "unsupported Oracle data type 101 encountered" error when attempting to retrieve data from a dataset based on a plsql stored procedure. I'm assuming this is related to a recent update on our Oracle 10g database to convert columns from number to binary_double.
Can anyone confirm if this is the case, and suggest a work-around? Is binary_double supported in RS 2005?
Thanks
RS uses MS .NET provider for Oracle which currently does not support binary_float/double.
The possible workaround is to cast binary_float columns to number in your SQL statement
select cast(my_bin_float_col as number) from ...
No comments:
Post a Comment