[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3002
  • Last Modified:

Error "Decimal's scale value must be between 0 and 28, inclusive." when using OracleConnection

When I'm consulting a query, appear this error. What can be? (File attached).

Thanks...
query.txt
Erro1.jpg
0
arthur_info
Asked:
arthur_info
1 Solution
 
slightwv (䄆 Netminder) Commented:
What is the return value for the function up in the declaration?

I'm also curious why you are trying to return an empty data table?
0
 
VenabiliCommented:
See http://www.devart.com/forums/viewtopic.php?p=35049&sid=6222eaef4cbf25b206250224c882c0c0

Basically it is a problem with the scale of the Number type through the adapter... so you need to use special types.

Alternatively you can get them as Strings and convert in your code (http://social.msdn.microsoft.com/Forums/en-US/sqlgetstarted/thread/f7b7636d-7475-4848-8bc0-d1c10e36707e shows an example how) but I kinda do not like this -- unneeded conversion...
0
 
arthur_infoAuthor Commented:
slightwv: I've returned an empty datatable because of the error.
Venabili:Yes, the problem is the adapter. OracleConnection doesn't support a number with a lot of decimal numbers... I've used an round(...,4) in the SQL and works fine.

Thanks all...

Arthur
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now