• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

XML record count

 
Chuck Lowry
Greenhorn
Posts: 13
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am using OracleXMLQuery to retrieve XML from our database and need to retrieve the total number of records in the XML. I am currently using the XPath count() function, but it takes too long for large queries. Is there a faster way to get the record count from the XML? Thanks.
 
Chuck Lowry
Greenhorn
Posts: 13
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
In case anyone else ever has this question...
If you are using OracleXMLQuery you can run the method getNumRowsProcessed() against your query object and return the number of rows. I'm still not sure of a better way to do it from the XML document, but if anyone has any ideas, please email me.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic