ORA-01460 unimplemented or unreasonable conversion requested
There are two posibilities in this case.
Remove the requested conversion from the SQL statement.
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.
Check the value in the variables
- Incompatible character sets can cause an ORA-01460
- Using SQL Developer, attempting to pass a string to a bind variable value in excess of 4000 bytes can result in an ORA-01460