When we migrated to 9i all of the number fields that were not specifically declared i.e. (number (3,2)) were converted to float(*)'s.

Has anyone had any experience with this phenomena? Were there any issues?

Could it lead to an ORA-01461 error?

Thanks,
cd