Select power(n,n) 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 AgrawalPosted Jan 13, 2015, 12:20 AM
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.