Updated on 2025-06-07 GMT+08:00

U0100077: GaussDB does not support XMLTABLE

Description

Database Type and Version

  • Source database type and version: Oracle versions supported by UGO
  • Target database type and version: GaussDB of versions earlier than V2.0-8.0

Syntax Example

This error is reported because GaussDB of versions earlier than V2.0-8.0 does not support XMLTABLE, for example:

SELECT * FROM XMLTABLE('/BOOKSTORE/BOOK' PASSING XML_DATA COLUMNS TITLE VARCHAR2(100) PATH 'TITLE', AUTHOR VARCHAR2(100) PATH 'AUTHOR');

Suggestion

No solution is available. You are advised to refactor application code or upgrade GaussDB.