Help Center/
Database and Application Migration UGO/
User Guide/
Syntax Conversion/
Conversion Error Codes/
Error Codes Generated During Conversion from Oracle to GaussDB/
U0100076: Functions cannot be used in GaussDB hierarchical queries
Updated on 2025-06-07 GMT+08:00
U0100076: Functions cannot be used in GaussDB hierarchical queries
Description
Functions cannot be used in GaussDB hierarchical queries.
Database Type and Version
- Source database type and version: Oracle versions supported by UGO
- Target database type and version: GaussDB versions supported by UGO
Syntax Example
SELECT * FROM TEST_KEEP WHERE ID=4 START WITH NAME='A' CONNECT BY PRIOR ID=FATHERID AND PRIOR DBMS_RANDOM.VALUE(0,1) IS NOT NULL;
Suggestion
No solution is available. You are advised to refactor application code or avoid using functions in hierarchical queries.
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