Category: Coding
-
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 namespace Looping through a cursor to add recursive nodes PART_CATALOG table consists of records in below structure Part_No Description UOM TEST1 test1 pcs TEST11 Test 1 pcs TEST111 111 VIAL Output XML looks like…
-
Build a RESTful API for IFS with WSO2 and knak.it connector
I have tried several different integration tools like Mulesoft, Azure Service Bus and and some native coding with IFS but nothing worked as good (and free) as WSO2 Enterprise Integrator so far. It’s a complete Integration tool kit with tons of features so you can basically integrate IFS with anything with right combination of configuration…
-
Build a RESTful API for IFS with WSO2 and knak.it connector
I have tried several different integration tools like Mulesoft, Azure Service Bus and and some native coding with IFS but nothing worked as good (and free) as WSO2 Enterprise Integrator so far. It’s a complete Integration tool kit with tons of features so you can basically integrate IFS with anything with right combination of configuration…
-
Execute batch script from Java
Java ProcessBuilder example, Execute OS process from java, Ping Java example
-
Include additional attachments in IFS e-mail report
One of our customers came up with a bit of a challenging requirement. Upon emailing a report to their clients, they need to attach documents connected to that record instance along with the mail. To attach a file in the event mail, you need to either have it as a binary object or the file must…