Unsupported Oracle data type 100

[Guest]

Hi;

I am getting the following on a DbCommand.ExecuteReader() using the
OracleClient:

+ $exception {"Unsupported Oracle data type 100
encountered."} System.Exception {System.NotSupportedException}

Any ideas?

--
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com

Cubicle Wars - http://www.windwardreports.com/film.htm

 

[Guest]

I get it if I have a BINARY_FLOAT or BINARY_DOUBLE column. Any idea why it
doesn't like these?

--
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com

Cubicle Wars - http://www.windwardreports.com/film.htm

 

[WenYuan Wang [MSFT]]

Hi Dave,

We need to perform more research on this issue . We will reply here as soon
as possible.
If you have any more concerns on it, please feel free to post here.

Thanks for your understanding!
Best regards,
Wen Yuan
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[WenYuan Wang [MSFT]]

Hi Dave,
Thanks for your waiting.

The OracleClient provider that ships in .NET 2.0 supports using Oracle's
10g client. However, It does not support the new data types introduced in
Oracle 10g (binary float and binary double) or the XML data type introduced
in 9i. The System.NotSupportedException will be thrown.

Please let me know if you have anything unclear. I'm glad to assist you.
Sicerely,
Wen Yuan
Microsoft Online Community Support

 

[Guest]

Ok. That's not a terribly clear error message the way it is written. And it's
a pretty poor implementation IMO if it does not support float & double.

--
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com

Cubicle Wars - http://www.windwardreports.com/film.htm

 

[WenYuan Wang [MSFT]]

Hi Dave,

Sorry for any inconvenient this caused. However, our product team has
noticed this issue and I think they will resolve such issue in the next
version of product.

Thanks again for your understanding.
Sincerely,
Wen Yuan
Microsoft Online Community Support