Latest revision as of 09:59, 7 October 2010

EclipseLink DBWS Service based on Stored Procedure

The use-case for this example is the creation of a Web service that exposes a Stored Procedure (or multiple procedures).
From the metadata for a Stored Procedure, it is not possible to determine the structure of the returned data. Therefore,
the Simple XML Format schema is used. The EclipseLink DBWS runtime produces an XML document that is simple and 'human-readable'.
Any combination of IN, OUT and IN OUT arguments are supported; in addition, procedures in packages that are overloaded -
same name, different parameters – are supported.