The OracleXMLQuery class provides XML conversion only for query strings or ResultSets. But in your application if you have PL/SQL procedures that return REF cursors, how would you do the conversion?
In this case, you can use the earlier-mentioned ResultSet conversion mechanism to perform the task. REF cursors are references to cursor objects in PL/SQL. These cursor objects are valid SQL statements that can be iterated upon to get a set of values. These REF cursors are converted into OracleResultSet objects in the Java world. You can execute these procedures, get the OracleResultSet object, and then send that to the OracleXMLQuery object to get the desired XML.
Related Questions
- The OracleXMLQuery class provides XML conversion only for query strings or ResultSets. But in your application if you have PL/SQL procedures that return REF cursors, how would you do the conversion?
- Does Warehouse Builder have a published metadata model with SQL based query capability and/or an Application Program Interface (API)?
- How Do I Parse a DTD Contained in a CLOB with the XML Parser for PL/SQL?
