How can i get right result using Power function.

Question

Select power(nn) as result from dual; If n as number :1-----------68 If n as binary_double :1-----------138 it gives right result.But i want extends the nth value it gives overflow error. *************Error***************** The following error has occurred: ORA-01426: numeric overflow ************* Error *****************

Vikram Agrawal · Answer

HI Dilshad The Power() function returns number if both params are number if any one of them is Binary_Double then it will return Binary_Double type. Binary_Double type has max precision as 53. if your value crosses this limit then only it will give you Overflow error. In your case i think you are passing values which produces a huge result that is why this error came. Thanks.