Problem is resolved, I used below query to use 'like' in soapui jdbc.
SELECT * FROM (SELECT * FROM <table> where row_key like concat(:custId,'%') )
It looks like you're trying to use Oracle parameter expansion. Try something like this:
context.expand('${Your JDBC step name#ResponseAsXml#//Results[1]/ResultSet[1]/Row[1]/custId[1]}')
You can also right-click in the query window and click 'Get Data' and then select the node directly. This is of course assuming you are only getting one custId per query
Hi Justin,
Thanks for your reply but I am not picking anything from response. that is a seperate step, as of now I am trying to fetch the data against :custId from oracle database [which in turn I am fetching from excel sheet (in JDBC test step by parameterizing) ]and trying to get records from oracle database after making a connectivity between JDBC step & my oracle database.
I just want to fetch the records from oracle database against custId defined in jdbc test step properties using "like".
Problem is resolved, I used below query to use 'like' in soapui jdbc.
SELECT * FROM (SELECT * FROM <table> where row_key like concat(:custId,'%') )
