Help Center/
Database and Application Migration UGO/
User Guide/
Syntax Conversion/
Conversion Error Codes/
Error Codes Generated During Conversion from Oracle to GaussDB/
U0100077: GaussDB does not support XMLTABLE
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.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
The system is busy. Please try again later.
For any further questions, feel free to contact us through the chatbot.
Chatbot