Toad World® Forums

XMLTable causing Code Explorer to stop parsing source?


The Code Explorer doesn’t fully populate all the functions and procedures for one of our packages. After a bit of commenting it appears that the following statement is the cause, functions and procedures above the statement appear in the code explorer, ones below don’t.

  SELECT record_count
    INTO v_tab_count
    FROM XMLTABLE( 'for $c in count(/data_file/record)
                       return <record_count>{$c}</record_count>'
                   PASSING v_xml_doc
                   COLUMNS record_count NUMBER PATH '.' );

This was also an issue in previous versions of SQL Nav.




Hi Gavin,

Thank you for sending us the details of the issue.

We have raise Tracker Story bug #46605545 for this issue you reported.

Thanks and regards,