Using the XML Query Result Set Interface

The CTX_QUERY.RESULT_SET procedure executes an XML query and generates a result set in XML.

Note: The Oracle Text Result Set Interface queries are not supported on shard catalog instances.