Invoke_String

NOTE: This procedure is deprecated. Use Invoke_Record_Impersonate.

Invokes an operation in the application server using an XML string.

FUNCTION Invoke_String (
   interface_         IN     type_interface_,
   method_            IN     type_method_,
   request_string_    IN OUT VARCHAR2,
   connection_string_ IN     type_connection_string_  DEFAULT NULL ) RETURN VARCHAR2;

Parameters

interface_
    Name of interface containing the requested operation.

method_
    Name of requested operation.

request_string_
    String in XML format.

connection_string_
    Optional connection string to an application server. If no connection string is supplied the call will be to the application server set in the configuration (Set_Plsqlap_Environment).

Record handling

No special considerations; Invoke_String does not have any input/output record.

Example

DECLARE
   Interface_ VARCHAR2(60) := 'Activity_Application_Queue_Definition';
   Operation_ VARCHAR2(60) := 'Query_Application_Queue';
   XML_       VARCHAR2(32000);

      BEGIN
   XML_ := '<APPLICATION_QUEUE_QUERY domain="*"></APPLICATION_QUEUE_QUERY>';

   dbms_output.put_line('Query:');
   Plsqlap_Server_API.Debug_Xml(XML_);

   XML_ := Plsqlap_Server_API.Invoke_String(Interface_,Operation_, XML_);

   dbms_output.put_line('Result:');
   Plsqlap_Server_API.Debug_Xml(XML_);

      END;

SQL> SET SERVEROUT SIZE 100000
SQL> /

      Query:
<APPLICATION_QUEUE_QUERY domain="*"></APPLICATION_QUEUE_QUERY>

Result:
<?xml version="1.0" encoding="UTF-8"?>
<APPLICATION_QUEUE_QUERY xmlns:fndas="urn:ifsworld-com:fndas" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="urn:ifsworld-com:application_queue-application_queue_query" fndas:state="new">
<CONDITION>
<APPLICATION_QUEUE domain="*" fndas:state="queried">
</APPLICATION_QUEUE>
</CONDITION>
<RESULT>
<APPLICATION_QUEUE ID="APPLICATION_MESSAGE_QUEUE-BATCH1" domain="*" fndas:state="queried" fndas:OBJ_VERSION="1" fndas:ENTITY_STATE="ACTIVE" fndas:CREATED_BY="SYSADM" fndas:CREATED_DATE="2002-01-21T12:13:10">
<DEFAULT_QUEUE>1</DEFAULT_QUEUE>
<DESCRIPTION>Default batch queue</DESCRIPTION>
</APPLICATION_QUEUE>
<APPLICATION_QUEUE ID="APPLICATION_MESSAGE_QUEUE-IN1" domain="*" fndas:state="queried" fndas:OBJ_VERSION="1" fndas:ENTITY_STATE="ACTIVE" fndas:CREATED_BY="SYSADM" fndas:CREATED_DATE="2002-01-21T12:13:10">
<DEFAULT_QUEUE>1</DEFAULT_QUEUE>
<DESCRIPTION>Default inbound queue</DESCRIPTION>
</APPLICATION_QUEUE>
<APPLICATION_QUEUE ID="APPLICATION_MESSAGE_QUEUE-NOTIFICATIONS" domain="*" fndas:state="queried" fndas:OBJ_VERSION="1" fndas:ENTITY_STATE="ACTIVE" fndas:CREATED_BY="SYSADM" fndas:CREATED_DATE="2002-01-21T12:13:10">
<DEFAULT_QUEUE>0</DEFAULT_QUEUE>
<DESCRIPTION>Notification queue</DESCRIPTION>
</APPLICATION_QUEUE>
<APPLICATION_QUEUE ID="APPLICATION_MESSAGE_QUEUE-OUT1" domain="*" fndas:state="queried" fndas:OBJ_VERSION="1" fndas:ENTITY_STATE="ACTIVE" fndas:CREATED_BY="SYSADM" fndas:CREATED_DATE="2002-01-21T12:13:10">
<DEFAULT_QUEUE>1</DEFAULT_QUEUE>
<DESCRIPTION>Default outbound queue</DESCRIPTION>
</APPLICATION_QUEUE>
<APPLICATION_QUEUE ID="APPLICATION_MESSAGE_QUEUE-TRASHCAN" domain="*" fndas:state="queried" fndas:OBJ_VERSION="3" fndas:ENTITY_STATE="ACTIVE" fndas:CREATED_BY="SYSADM" fndas:CREATED_DATE="2002-01-21T12:13:10">
<DEFAULT_QUEUE>0</DEFAULT_QUEUE>
<DESCRIPTION>Trashcan queue</DESCRIPTION>
</APPLICATION_QUEUE>
</RESULT>

PL/SQL procedure successfully completed.