SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to handle numeric overflow

921066Nov 30 2015 — edited Nov 30 2015

I'm working on a customer data. I'm trying to create a table which has one field using Power(2,data).But my table creation query is not working. It is giving

numeric overflow"

*Cause: Evaluation of an value expression causes an overflow/underflow.

*Action: Reduce the operands.

I tried to make the data type of the field where I'm using Power function is long and number(38) but still it is giving the same error.

Sorry, I can't share the data as it is customer data.Can you please suggest me some solution to handle this error

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 28 2015

Added on Nov 30 2015

11 comments

3,484 views