I got ” ORA-01460: unimplemented or unreasonable conversion requested ” error in Oracle database.
ORA-01460: unimplemented or unreasonable conversion requested
Details of error are as follows.
ORA-01460 unimplemented or unreasonable conversion requested Cause: The requested format conversion is not supported. Action: Remove the requested conversion from the SQL statement. Check the syntax for the TO_CHAR, TO_DATE, and TO_NUMBER functions to see which conversions are supported.
unimplemented or unreasonable conversion requested
This ORA-01460 errors are related with the requested format conversion is not supported.
To solve this error, you need to remove the requested conversion from the SQL statement.
Check the syntax for the TO_CHAR, TO_DATE, and TO_NUMBER functions to see which conversions are supported.
Or Incompatible character sets between Oracle Server and Client can cause this error, so check and fix the character set of Client.
Do you want to learn Oracle Database for Beginners, then read the following articles.
Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )