Error ORA - 01460 in Oracle 11g

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.

0

Nipun Tomar13y ago

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.

0

Vulpes13y ago

Not a simple answer but check this out:

http://www.dba-oracle.com/t_ora_01460_unimplemented_or_unreasonable_conversion_requested.htm

0