Category: XML

From time to time you’ll have to represent your data stored in a database in an XML format, eg. to exchange it between systems, to send it to external parties, etc. In an article on All Things Oracle I give an introduction on how you can generate XML documents: Part one,  in SQL Part two, in […]

Did you ever needed your table data in an XML format? Well, it isn’t that hard…  Oracle provides several ways to generate XML, in both SQL and PL/SQL. I wrote an article on All Things Oracle in which I explain step by step how you can generate XML from table data. In this first part […]

When you try to convert an xml file, which has a tag that contains for example one or more pdf files, into an XMLTYPE object, you will get the following error: ORA-19011: CHARACTER string BUFFER too small This error will be thrown because the content of a tag of an XMLTYPE is limited to 4000 […]

Apex and Charts In Application Express 2.2 and previous releases is it possible to build a Chart with the use of the SVG Viewer technology of Adobe. A time ago Adobe has decided to discontinue support for Adobe SVG Viewer starting from January 1, 2008. They even plan to remove Adobe SVG Viewer from the […]

Apex: XLIFF Translator, generate the translated file. The final step in our translation process is exporting the translated data back to an xml-file; i.e. the reverse process of step 1 where we translated an xml-structured file to a relational table-structure. This time, the relational data has to be converted back to the original xml-structure (similar […]