Oracle Adapter scale error

[Guest]

I am using the Oracle Data adapter and calling a stored procedure that does a
select of a table and returns it.

I get this error: Decimal's scale value must be between 0 and 28, inclusive.

Is this a limitation of the adapter?
First of all the column that holds the value that is creating this error is
defined as a FLOAT in Oracle not a DECIMAL.
Secondly, the limit of a decimal is 38 not 28.

Any ideas?

 

[Cowboy \(Gregory A. Beamer\)]

There are definitely limits in the Adapters for Oracle. It is better to move
to Oracle's ODP.NET, as it is more in tune with Oracle. It sounds like you
might have a mapping issue here, which means you will have to take complete
control of the DataSet creation and not rely on anything in the drag and
drop realm. Yes, it is a pain, but the drag and drop is designed to fit the
majority of situations, not all.

As for the scale issue, in .NET it will truncate beyond 29 places. With SQL
Server, you can extend it to the full 38 and have all digits on one side of
the decimal point.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

*************************************************
Think outside of the box!
*************************************************

 

[Guest]

Yea. I'm finding that is the case as well.
As for ODP.NET, we have been trying to switch over to it for months; ever
since they came out with the .NET 2.0 version. However, they are working on
some bugs that are show stoppers for us and I haven't heard from them in
awhile.

Thanks,

Chris

 

[Cowboy \(Gregory A. Beamer\)]

Always fun to play on the bleeding edge.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

*************************************************
Think outside of the box!
*************************************************