How to resolve this error
ORA-25137: Data Value out of range
Cause: value from CAST operand is larger than CAST target size
Action: Increase size of CAST target.
Inside CAST I used one column value having datatype length 18 and then after compute again I used another CAST to convert its Datatype having same length 18 but after execute I got an error as I mentioned above. Here is the code:
CAST((CAST(col1 as number(18,0)) * 100)/col2 as varchar(18))
How to resolve this error?
try
as varchar2(18 char)
because varchar(18) means 18 bytes.