I have a request.
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
The response for this is :-
Now I have a database in which I have following two columns : -
How can I implement this query in CA LISA 9.5.1 : - select superhero from Movies where Name='BruceWayne'; ??
How can I pass the the value which is in request into the SQL query, so that the value I am sending in the response can be read from it ??