CHAPTER 20Build an XML Database OCI Application

Many applications require access to database data, because they typically are designed to return large result sets or to update and retrieve data frequently. While Oracle offers PL/SQL as an in the database programming language, many applications need the flexibility and functionality of C or need to offload program logic from the database. This is where building your application using the Oracle Class Interface (OCI) libraries can be a real value. Previous Oracle Database releases included no OCI support for the XMLType. Applications had to serialize the output from a query and reparse using DOM or SAX APIs on the client to process XML. This processing model has distinct disadvantages when the ...

Get Oracle Database 10g XML & SQL: Design, Build, & Manage XML Applications in Java, C, C++, & PL/SQL now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.