U0100087: The precision of the returned value of DBE_UTILITY.GET_TIME in GaussDB and Oracle is different
Description
In Oracle, the returned value type of DBMS_UTILITY.GET_TIME is NUMBER. In GaussDB, the default returned value type of DBE_UTILITY.GET_TIME is BIGINT (8 bytes). The value length of DBE_UTILITY.GET_TIME and DBMS_UTILITY.GET_TIME is different.
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
DECLARE M_LAST_TIME NUMBER(10); BEGIN M_LAST_TIME:=DBMS_UTILITY.GET_TIME; END;
Suggestion
Change the returned value precision.
Execute the following statement:
DECLARE M_LAST_TIME NUMBER(20); BEGIN M_LAST_TIME:=DBE_UTILITY.GET_TIME; END; /
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.
For any further questions, feel free to contact us through the chatbot.
Chatbot