Debug_Xml

Returns the value of an XML string somewhat formatted. The procedure use the DBMS_OUTPUT package to display the data.

PROCEDURE Debug_Xml ( xml_ IN VARCHAR2 );

Parameters

xml_

Example

SQL> SET SERVEROUT SIZE 100000
SQL> call Plsqlap_Server_API.Debug_Xml(xml_);
<?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.