U0100069: GaussDB does not support the system function

Description

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

For some system functions that are not supported by GaussDB (A-compatible mode), UGO allows you to replace them with custom functions.

For example, Oracle provides the LOBMAXSIZE constant in the DBMS_LOB package, but GaussDB does not.

SQL statement example of the source database:

INSERT INTO LOBDEMO(KEY,BFILE_COL) VALUES (-1,DBMS_LOB.LOBMAXSIZE);

If UGO user-defined function conversion is enabled, a function is converted to a UGO custom constant, for example:

INSERT INTO LOBDEMO(KEY,BFILE_COL) VALUES (-1,DSC_ORA_EXT.DSC_PKG_DBMS_LOB.LOBMAXSIZE);

Suggestion

Modify UGO user-defined function conversion. You can download source code of the converted custom function on the Downloads > UGO-defined Functions page.