Author: Arun Raj
-
Create XML Using SQL Statements
In this post we will take a look at how to create XML using SQL Statements. The following functions will be used to generate the output in XML Format. XMLElement () XMLForest () XMLSequence () XMLAgg () The combination of the above three functions will let us create some very fancy and complex XML Outputs. Lets…
-
Create XML Using DBMS_XMLDOM
DBMS_XMLDOM The DBMS_XMLDOM package is used to access XMLType objects, and implements the Document Object Model (DOM), an application programming interface for HTML and XML documents. The Document Object Model (DOM) is an application programming interface (API) for HTML and XML documents. It defines the logical structure of documents, and the manner in which they are accessed…
-
Password Protect PDF Output
In this post, we will explore how we can password protect PDF output generated by a Oracle XML Publisher Report. Check out my earlier posts on XML Publisher for more details on XML Data Template, RTF Template, Triggers etc. Now lets take a look at what we are planning to build today. You can download…
-
Submit XML Publisher Report from PL/SQL
Today, let us look at how we can submit XML Publisher report from PL/SQL. Now you might think that I already know how to use “fnd_request.submit_request” to submit a concurrent program. Right? Well, things are a little different when it comes to XML Publisher Report / Concurrent Program. First, let us see what happens when you submit a XML…
-
Oracle BI Publisher Desktop Tool
Today we will take a look at the Oracle BI Publisher Desktop Tool. This is one tool that I love. If you are working on XML Publisher Reports, this is a must have tool. This tool allows you to test your RTF Template on your local system (desktop / laptop) and make any changes necessary before uploading…