You have chosen to sponsor your bid up to a maximum amount of .
I need a Oracle plsql package which can call a webservice on an Microsoft IIS server.
The webservice returns a .NET DataSet
A function in the plsql package must return the content of the one of the tables from the DataSet.
The plsql function take one input parameter, namely the tablename as a varchar2 string.
The plsql function returns a table. The attached document show an example how this can be done.
I will not supply the .NET webservice source code, you must create this your self for testing.
The webservice function take no input and return a DataSet
I need you to send me all the scripts needed to create the package, etc. on the Oracle Database that handles the webservice call and extract the table data from the .NET DataSet.