How to use LIKE SQL Operator in Adapter Service

, ,
1

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.

Thanks,
Varun

2

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?

Regards,
Holger