MTK Parameter

Parameter

convertPackageMethod

Type: string

Desc: How to migrate Oracle Package to openGauss/MogDB

openGauss database version greater than or equal to 3.0.0 Default package

openGauss database version greater than or equal to 2.1.0 can be configured as package or schema

openGauss databases smaller than 2.1.0 can only be configured as schema

Default: package

Option:

• schema
• package

enableAutoAddParenthesesForFunc

Type: bool

Desc: Enable automatic conversion, add parentheses to call procedures/function without parameters

Default: false

Add: v2.8.1

customFuncTrans

Type: []TranFunc

Desc: Custom conversion PLSQL regular expression.

For example, migrating Oracle without parentheses to call the function internally by adding this parameter to complete the rewriting

Default: null

Example:

Rewrite Oracle Call No args function

{
  "customFuncTrans": [
    {
      "regStr": "(?i)\\b(ORA_MTK\\s*\\.PROC_TEST_002)(\\s*[^\\(]\\b)",
      "replace": "${1}()${2}"
    },
    {
      "regStr": "(?i)\\b(ORA_MTK\\s*\\.F_NO_ARGS)(\\s*[^\\(]\\b)",
      "replace": "${1}()${2}"
    }
  ]
}

Add: v2.8.1