Are you sure you are using a RDBMS? In a RDBMS there are no such things as 'fields', there are only *columns*
And yes, when you are using incorrect datatypes, Oracle will convert this automagically to the target datatype, to help you out.
So it seems you have some very basic things wrong.
Senior Oracle DBA