Error ORA - 01460 in Oracle 11g

Question

What is the cause of the Error ORA-01460? And how can it be avoided?

Vulpes · Answer

I think I'd just concentrate on the basic reason for this error which is: 'Unimplemented or unreasonable conversion requested' If you check this link to see which data conversions are and aren't allowed: http://docs.oracle.com/cd/B19306_01/server.102/b14200/sql_elements002.htm this error should occur if you try one which isn't allowed such as converting a BLOB to a number or a BINARY_FLOAT to a Datetime.

James Tomar · Answer

Thanks Vulpes I read it but this is really complicated :) As the reason is very clear and not the solution as i have tried a lot. So i can say that my problem is still not solved. Can u provide me something else to understand.

Vulpes · Answer

Not a simple answer but check this out: http://www.dba-oracle.com/t_ora_01460_unimplemented_or_unreasonable_conversion_requested.htm