How to Create XML documents from within a PL/SQL block?
Saturday, January 10, 2009Posted by
Tech Talker
0 Comments
The Oracle XML publisher can use the dbms_xlmgen package, but note that the XML calls are embedded into the SQL, not PL/SQL.
The dbms_xmlgen procedure can be extremely useful for quick retrieval of Oracle records, formatted for web browser display. With these formatting procedures you can display the output of any query directly to the screen, and you have an easy XML display program. The best part comes with easily formatting Oracle reports. XML Publisher is made to accept XML that looks just like this and form extremely detailed reports using templates made in Microsoft Word.
[Source: oranet.com]
The dbms_xmlgen procedure can be extremely useful for quick retrieval of Oracle records, formatted for web browser display. With these formatting procedures you can display the output of any query directly to the screen, and you have an easy XML display program. The best part comes with easily formatting Oracle reports. XML Publisher is made to accept XML that looks just like this and form extremely detailed reports using templates made in Microsoft Word.
[Source: oranet.com]
Subscribe to:
Post Comments (Atom)