Converting a string to number and limiting precision and scale
Marius2Aug 15 2008 — edited Aug 20 2008I have a function that I run from a insert select statement. The purpose of the function is to convert extract the number from the text string and convert it into a number. This part works. The problem lately is that I receive ORA-01438, that the precision is larger than allowed in the target column.
Is there a easy way to check the precision of a number?