SQL Query Validation Fails for DB Adapter When Variable Is Not Bind To A Column

(Doc ID 2383188.1)

Last updated on APRIL 12, 2018

Applies to:

Integration Cloud Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

An integration is using the Database adapter.
During the adapter configuration for a SQL query, the validation is failing with the following exception:

Error: Failed to generate XML Schema Definition for the SQL query. Please check the SQL Query entered. Refer Oracle documentation for further information.

Error: ORA-00920: invalid relational operator


1. Create the table INVENTORY_VIEW in a database.
2. Create a database connection
3. In an integration configure the database adapter to invoke SQL
4. Use a variable (#VAR):
  - to compare it with null
  - to compare it with a value
  - in a function as a parameter
In each case the validation will not be successful.
5. The validation works in each case if we replace the variable with a

Changes

The SQL Validation fails if a variable (#VAR) is used in the following ways:
1. to compare it with null

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms