Plsqlap_Server_API Overview

The package Plsqlap_Server_API is used to invoke operations in Middleware Server components, and to post messages to the IFS Connect messaging system.

No meta data is available to the PL/SQL Access Provider. It is the users responsibility to ensure that buffers, records and XML strings have a valid structure.

When the package is loaded into memory (the first time it is called in a session) the environment is set up according to the values stored in the table PLSQLAP_ENVIRONMENT_TAB.

 

Methods for BizAPIs

Procedure Post_Outbound_BizAPI Post an asynchronous outbound BizAPI message
Procedure Invoke_Outbound_Request_BizAPI Invoke an outbound BizAPI synchronously and wait for the reply

 

Methods for calling IFS Application Server server operations

Procedure Invoke_Record_Impersonate Invoke a server operation, passing a record or document

 

Other Methods

Procedure Post_Event_Message Creates an event message in the Application Server queue
Procedure Set_Plsqlap_Environment Updates the PL/SQL AP environment table and sets server environment variables

 

Data Types and Constants

Type List Subtype  list

 

Protected and Private Methods

Procedure Invoke_Record_ Invoke a server operation, passing a record or document
Procedure Get_Wallet_Info_ Retrieve wallet information from the PL/SQL AP environment table
Function Get_Persistent_Con_ Retrieve value of environment variable HTTP_PER_CONS.
Function Ping__ Used to check the implementation condition
Function Ping_Result__ Used to check the implementation condition
Function Test_Find_Queue__ Used to check and benchmark pre-routing phase.
Procedure Exists_Tmp_Record__ Used for internal tests.