Oracle Adapter scale error

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?

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!
*************************************************
"Oldman" <Oldman@discussions.microsoft.com> wrote in message
news:43CA36AD-81A0-4F04-A22B-8D77CE58FEA0@microsoft.com...
>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?

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)" wrote:

> 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!
> *************************************************
> "Oldman" <Oldman@discussions.microsoft.com> wrote in message
> news:43CA36AD-81A0-4F04-A22B-8D77CE58FEA0@microsoft.com...
> >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?
>
>
>

Always fun to play on the bleeding edge. :-)

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

*************************************************
Think outside of the box!
*************************************************
"Oldman" <Oldman@discussions.microsoft.com> wrote in message
news:49E3C401-A71E-4259-B0D7-1A1E1D711FEB@microsoft.com...
> 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)" wrote:
>
>> 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!
>> *************************************************
>> "Oldman" <Oldman@discussions.microsoft.com> wrote in message
>> news:43CA36AD-81A0-4F04-A22B-8D77CE58FEA0@microsoft.com...
>> >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?
>>
>>
>>