Updated on 2025-06-07 GMT+08:00

U0100071: Dynamic SQL statements cannot be automatically converted

Description

This error is reported because UGO cannot automatically convert dynamic SQL statements in Oracle PL/SQL.

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

BEGIN 
  EXECUTE IMMEDIATE 'SELECT 1 FROM DUAL';
END;

Suggestion

Use the SQL Conversion module to convert dynamic SQL statements.