Query : Right parenthesis missing

Learn Academy Feedback
1

Hello Team,

Am trying to execute a query, which is executing fine in toad, but giving error in UiPath…
Execute Query 15: ORA-00907: missing right parenthesis

Query shows red zigzag line for this

a.table1 LIKE'%"A:{"B":"PASS","C":"PASS"%'

Any Help on what wrong am doing

2

@hss

Due to double quotes and { you are facing the issue

Give a try of below

"a.Table1 LIKE '%' A:{'B':'PASS', 'C': 'PASS' '%'"

Hope this works

Thanks

1 Like
3

I did try that… But didn’t work…