DQ Failed With Error Unexpected Exception Occurred, ORA-01460 (Doc ID 2857853.1)

Last updated on MARCH 30, 2022

Applies to:

Symptoms

DQ execution failed with below error in DB version 12.1
- Unexpected Exception Occurred, ORA-01460: unimplemented or unreasonable conversion requested -> DQ Batch Execution -Failed
But the same DQ ran fine in other environment which database version is 19c

Below is the scenario tried :

This DQ script contains $ sign and script length is over 4000.

It doesn't seem like the $ sign interpreted correctly when the script length is over 4000.
When $ sign replaced to other character then verified the DQ completed regardless of script length.

1) LENGTH(V_BUSS_SQL) <= 4000, Regardless of “$” DQ completed successfully
2) LENGTH(V_BUSS_SQL) > 4000, if script contains “$” then DQ failed with ORA-01460
3) LENGTH(V_BUSS_SQL) > 4000 but script doesn’t contain “$” then DQ completed successfully
- i.e. replaced $ to D, then DQ success

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.