This discussion is archived
0 Replies Latest reply: Apr 2, 2013 9:30 AM by kron777 RSS

PL/SQL Web Service taking in a dynamic set of parameters

kron777 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points