Plsqlap_Server_API Overview

The package Plsqlap_Server_API is used to invoke operations in Extended 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 Messaging and BizAPIs

Procedure Post_Message Post an asynchronous outbound message
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

Other Methods

Function Ping_Result Used to check the implementation condition
Function Find_Queue Finds a queue in the routing tables
Procedure Debug_Xml Returns an XML string formatted
Procedure Set_Plsqlap_Environment Updates the PL/SQL AP environment table and sets server environment variables

Data Types and Constants

Type List Subtype  list

Private Methods

Procedure Create_Application_Message Creates an application message in the Extended Server queue
Procedure Post_Event_Message Creates an event message in the Extended Server queue
Procedure Invoke_Record_ Invoke a server operation, passing a record
Procedure Invoke_Record_Authorize_ Invoke a server operation, passing a record
Procedure Exists_Tmp_Record__  

Deprecated Methods

Procedure Invoke_Message  
Function Invoke_String  

Removed Methods

Procedure Create_Connectivity_Message