I am trying to download data from an E-Business application by creating a web service. So far I have created a BPEL synchronous web service using SOA, JDeveloper and an Oracle Application partner link. I have been able to return a single record but when I use a LIKE query thar returns more than 1 record the web service just hangs.

Does anyone know whether synchronous BPEL web services are intended to return more than a single record (and if so how does one setup the process to do so)?