Conversion

consulting · Post by **consulting** » Fri Mar 06, 2009 11:26 am

In my sequence While I load into oracle table from ds the job got aborted and the sequence got failed

In Unix box the log has written like below

Record 54626: Rejected - Error on table XXX, column SALARY(decdimal(13,2)).
ORA-01460: unimplemented or unreasonable conversion requested

throbinson · Post by **throbinson** » Fri Mar 06, 2009 11:43 am

There's a new feature of Oracle due to the U.S. Economy. If the Salary field is of type "Auto Exec" or "Financial Exec" then any salary over 999,999,999.99 will automatically be rejected as unreasonable.

Mike · Post by **Mike** » Fri Mar 06, 2009 12:04 pm

Does your log really say "decdmal"? That would certainly qualify as an unreasonable conversion request.

Mike