DBAdapter Invoke Wizard Failed With Error "Failed to generate XML Schema Definition for the SQL query"
(Doc ID 2698949.1)
Last updated on AUGUST 07, 2020
Applies to:
Oracle Integration - Version 17.4.1 and laterInformation in this document applies to any platform.
Symptoms
On : NA version, Integration RT
While using the below query condition in OIC DB Adapter invoke flow, it fails with error.
Query Where Condition:
WHERE pay_recon.ofa_check_id = t24_ack.check_id and trunc(t24_ack.last_update_date) between #LASTJOBRUNTIME and trunc(sysdate))
ERROR
-----------------------
Error: Failed to generate XML Schema Definition for the SQL query. Please check the SQL Query entered. Refer Oracle documentation for further information.
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create DBAdapter query with where condition as above and note it fails to generate the schema.
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |