PLSQL Access Provider 

The PLSQL access provider will allow invocations of server operations from PLSQL code executing within Oracle 8.1.6 (or higher) database. The PLSQL access provider is used to send messages, call outbound BizAPIs, and to invoke any operation implemented with IFS Application Server.

Important! Synchronous invocations will execute in their own transactions, separate to any open transaction within Oracle. An Oracle rollback after a synchronous invocation using PLSQL access provider will not roll back the effects of the invocation. However asynchronous postings done with for example Post_Message will be part of the Oracle transaction and included in rollbacks.

See also About PLSQL Access Provider.

Reference Material

• Plsqlap_Server_API Overview
• Plsqlap_Document_API Overview
• Plsqlap_Record_API Overview

• Plsqlap_Buffer_API Overview

   

Note: The Plsqlap_Buffer_API package is private and must only be used internally by the Plsql Access Provider.

Note: Packages Plsqlap_Record_API and Plsqlap_Buffer_API have been deprecated and will not be maintained any more. The new package, Plsqlap_Document_API, should be used instead of Plsqlap_Record_API.