Siebel Connector for Oracle Applications > Developer Procedures > Understanding the Oracle Procedure Adapter >

Operational Summary

The Oracle Procedure Adapter is used to invoke any stored procedure on the external database. In turn, this is used to move data from interface (buffer) tables to Oracle base tables. It includes error-handling logic to promote reliable data exchange by appropriately managing exceptional conditions.

The Adapter runs a stored procedure in the Oracle Applications database through an ODBC call. Oracle supplies an API, FndAPI, which is a stored procedure. This procedure can start another stored procedure. When the called procedure completes, FndAPI returns control- and completion-error codes to the Oracle Procedure Adapter.


 Siebel Connector for Oracle Applications 
 Published: 18 April 2003