How to fixed the error "OCI-22053: overflow error".  While working in Reporting Services I get an error:

OCI-22053: overflow error

You normally get this error because the returning dataset cotains a precision decimal values that is larger then the current dataset can support. Oracle number data type supports a larger precision then what the current dataset can hold.

To get get around this issue just truncate the precision number down to a supportive level. You can do this by using the Round or TRUNC functions.

• Add New
• Search

Comments (2)

• |139.149.1.xxx |2011-01-26 15:12:55 ASHWIN
  THIS HAS SOLVED MY PROBLEM THANKS.

• |202.70.46.xxx |2011-12-24 02:27:07 Gunner  - Thank you
  It did work for me. Thank you

Write comment

Your Contact Details:

Name:

Email: do not notifynotify

Website:

Comment:

Title:

Message:

Security

Please input the anti-spam code that you can read in the image.

"