How to use LIKE SQL Operator in Adapter Service

Hi Experts,

Could you please help me how to write SQL query with LIKE Operator, my SQL dynamic query is

select line,groupnumber,groupdetails, roundnumber from XXX_EAM_DETAILS where “NameOfOperator” LIKE ‘?%’

When I try with above query, I could not get result, it is throwing some error , means

(72000/1006) ORA-01006: bind variable does not exist
ORA-01006: bind variable does not exist

Please help me, how to use LIKE operator in AdapterService.


Hi Varun,

the question mark represents the input variable of the Adapter service.

See JDBC Adapter Users Guide for further informations.

Can you provide a sample with a complete Query (without variable) and the expected results?