How to use DBMS_XMLDOM to create XML from PL SQL

This example shows how to create an Oracle XML object using DBMS_XMLDOM package. It includes XML declaration (Version and Charset)XML namespaceLooping through a cursor to add recursive nodes PART_CATALOG table consists of records in below structure Part_NoDescriptionUOMTEST1test1pcsTEST11Test 1pcsTEST111111VIAL DECLARE L_XMLTYPE XMLTYPE; L_DOMDOC DBMS_XMLDOM.DOMDOCUMENT; L_ROOT_NODE DBMS_XMLDOM.DOMNODE; PARTS_ELEMENT DBMS_XMLDOM.DOMELEMENT; PARTS_NODE DBMS_XMLDOM.DOMNODE; PART_ELEMENT DBMS_XMLDOM.DOMELEMENT; PART_NODE DBMS_XMLDOM.DOMNODE; PART_NO_ELEMENT DBMS_XMLDOM.DOMELEMENT;... Continue Reading →

Website Powered by WordPress.com.

Up ↑