My Oracle Support Banner

SQL Query Cannot Pass SQL Validation With Sybase Adapter On OIC Gen2 (Doc ID 2956346.1)

Last updated on JUNE 20, 2023

Applies to:

Oracle Integration-OIC - Version 23.3.3 and later
Information in this document applies to any platform.

Symptoms

 Binding parameters cannot pass SQL validation with Sybase Adapter. Trying to use below SQL query, the validation failed.

1. select * from table_name where user_type = #USERTYPE

 

2. SELECT * from table_name WHERE user_type = #user_type

 

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
Cause
Solution
References


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