There is no error message. It is a discrepancy found out by comparing the following:
Inserted a value 0.16810240488058710806053994064187 into a field
defined as NUMBER(22,16)
Here, Oracle should round off the value automatically.
When the field in a simple sql statement in TOAD was selected , <0.
168102404880587> is returned.
<0.1681024048805871> was expected instead; 16 decimal places.
Does TOAD do further rounding/truncation? If yes, how can the precision be controlled or expanded?
When run as a script, try setting the column numwidth like this:
set numwidth 30 <---or whatever number
select * from <table>;
Now press F5