SOAP

SO-S-14 SOAP & remote data sources

This example demonstrates the processing of a result set obtained from a PL procedure defined on a remote database.
The example shows a remote execution of a PL procedure against Microsoft SqlServer and Oracle DBMS.
The remote procedure is called via rexecute(). The result set is converted to an XML document by a local PL procedure that can then be called via SOAP. The demo VSP pages offers a form to accept DSN, login info and a search string. A soap_call() is executed with these parameters, and the result is parsed with an XSL-T engine for HTML output.

Configure this example for SQLServer by loading the ms.sql script using the ISQL tool on behalf of the demo user.
Make sure the demo Northwind DB is installed.
Create a DSN to the SQLServer DB.
Grant rexecute on DSN to the SOAP_SO_S_14 user: GRANT REXECUTE on [SQLServer DSN] to SOAP_SO_S_14;

Configure this example for Oracle by loading the ora.sql script using the SQLPLUS tool on behalf of the demo user.
Make sure the Oracle demo DB is installed.
Create a DSN to the Oracle DB. The driver must be 'Microsoft ODBC Driver for Oracle'.
Grant rexecute on DSN to the SOAP_SO_S_14 user: GRANT REXECUTE on [Oracle DSN] to SOAP_SO_S_14;