Automate IFS Printing via PL/SQL

Automatically printing an IFS report during a business transaction is one of the most common questions asked by customers. In this post I've described the basic PL/SQL logic which needs to be written to automate report printing without popping up the print dialog.

Check XSL Transformer Output

In IFS Cloud, there's no easy way to test the transformer output. Visual studio Enterprise or Professional versions has a XML editor where you can easily test the transformer output but the Community edition does not have this feature. If you have Visual Studio Enterprise or Professional, check below link on how to do that.... Continue Reading →

Using Functions in Oracle SQL

Oracle subquery using WITH clause is a popular choice among the developers. From Oracle 12C it's possible to define PLSQL function inside WITH clause. It's a handy feature which is really useful when making complex queries

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 ↑