I'm rubbing my crystal ball, but can't see a clear answer.
It is too bad you did not share with us EXACTLY
what you tried to do or even the EXACT error message;
so we might have a clue regarding your specific problem.
So I guess you'll need to wait for somebody whose crystal ball is working better than mine.
I am trying to take data (specified as Int or Smallint in Sybase) and insert it into an Oracle database column which is specified as NUM(15). I am not doing this manually. There are processes running that are taking the data from a Sybase table mapping it into an Oracle table, thus taking alarm info from Sybase and creating a ticket through Remedy and stored in Oracle.
The error we're getting in the our log is:
Caught an Exception:
Remedy Error #310
Text: check result - Error - Value has wrong data type
for the field, 536871338
Value has wrong data type for the field, 536871037
Value has wrong data type for the field, 536871052
Value has wrong data type for the field, 536870912
Not one of the Integers from Sybase is being inserted into Oracle.