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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.