How I Built a Chatbot for IFS with Free and Open Source Tooling…

Love them or hate them, chatbots will be a big part of tomorrow's technology. Chatbots have become extraordinarily popular in recent years and applications in this area is getting wider each day. With the increase of integration capabilities of messaging platforms, rise of AI and the low code chatbot platforms, building a chatbot has been... Continue Reading →

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 ↑