Create a simple Webservice in BPEL 10g

How to create a very simple synchronous web service in BPEL 10g. This simply takes a single input, passes it to a SQL statement and returns none, one or more collections of data.

Drop Box Link