لطفا منتظر باشید ...
Designing the Framework
The premise for all OCI applications is that they need to connect to Oracle databases and retrieve, insert, or update data. In the case of XML, this data may be stored in XML format or generated from relational tables. For this example application, you will use OCI to generate an XMLType from a SQL/ XML query over relational tables from the SH sample schema. However, instead of simply returning a serialized stream of the data that would need to be reparsed, you will return an XMLType DOM called an XOB (XML object) that can be accessed directly through the new XML* APIs. You will then update the XOB and serialize it for consumption or display. You can also save it back to the database.The steps to create such an application are as follows:Initialize the OCI application context, handles, environment, etc., with the boilerplate code.
Initialize the OCIXMLDB and XDK contexts to operate on an XOB.
Log on to the database and submit the SQL/XML query.
Cast the result to an XDK xmldocnode to prepare it for DOM operations.
Perform DOM operations with the XML* APIs.
Save the XOB.
Serialize the XOB or save it back to the database with OCI.
These steps are used in the following command-line xmlupdate application that can accept as parameters the SQL/XML query, the XPath expression to the location to be updated, and the update data.
