OraFAQ Forum: JDeveloper, Java & XML » How return WebService in SOAP message multirows from DB select

Home » Developer & Programmer » JDeveloper, Java & XML » How return WebService in SOAP message multirows from DB select

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How return WebService in SOAP message multirows from DB select [message #117417]

Wed, 27 April 2005 02:54

d0n4ld
Messages: 2
Registered: April 2005
Location: CR - Prague

Junior Member

I have creating simple PL/SQL WebService by the example on OTN
http://www.oracle.com/technology/obe/obe9051jdev/WebServicesOBE/OBEWebServices.htm
This works great ! But this example fetch and return only one row from select.
Now, i need develop some Webservice, which can fetch and return more than one row. I need to get multirows result in SOAP message.

Example of webservice at this link
http://webservices.oracle.com/ws/emp/oracle.ws.scott.OTNDeptEmp is exactly what i need to develop.. and some GET functions that contains that webservice..sometime returns rows in ROWSET format and sometime in VARRAY format
Could you please tell me how can i develop this Webservice with multirow return in SOAP message?

Thank you for your help

Report message to a moderator