In PL/SQL how to know if an amount variable which is of NUMBER type has more than 2 decimal places. Users should enter only 2 decimal places as it's an amount. But original coder forgot this and users can enter any amount of decimal places like 12.34567 etc. Values should actually have only 2 decimal places to reflect prices like 123.45 etc. If More than 2 DECIMAL places we will give an error.
How to do this in PL/SQL?