Oracle 11.2.0.3

Currently we have a pl/sql web service taking in 2 static parameters and returning a varchar2 response.

I was asked today if it's possible for a web service to take in a dynamic set of parameters and return a corresponding set of results. It's as if I need to pass the web service a table with two columns and return a table of one column.

For example:

                    Input                          Output
          1 2                             3
          3 4                             7 
          5 6                            11

output being in XML of course. It is possible?

Edited by: user13007502 on 02-Apr-2013 09:28