Hi Team,
I was getting below error when i am executing the below update statement.Please suggest
UPDATE memory
set Schip = CASE WHEN level=84 THEN round(1000*(exp((column8-39.6383085)/106.7937530)/(1+exp((column8-39.6383085)/106.7937530))),1)
WHEN level=12 THEN round(1000*(exp(column8-69.3524112)/166.0747276)/(1+exp((column8-69.3524112)/166.0747276))),1) END
where level in (84,12);
column is number data type and schip is also number datatype.
I used cast(column8 as number ) instaed of directly column8 but still i got same error.
SQL Error: ORA-01426: numeric overflow
01426. 00000 - "numeric overflow"
*Cause: Evaluation of an value expression causes an overflow/underflow.
*Action: Reduce the operands.
Thanks