Help Center/ Database and Application Migration UGO/ User Guide/ Syntax Conversion/ Conversion Error Codes/ Error Codes Generated During Conversion from Oracle to GaussDB/ U0100087: The precision of the returned value of DBE_UTILITY.GET_TIME in GaussDB and Oracle is different
Updated on 2025-06-07 GMT+08:00

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;
/