数据仓库服务 GaussDB(DWS)-VARRAY

时间：2025-02-12 15:04:59

VARRAY

REF CURSOR定义为返回参数。

设置plSQLCollection=varray后进行迁移。

输入： VARRAY

     
          CREATEOR REPLACE TYPE TYPE_RMTS_ARRAYTYPE IS TABLEOF VARCHAR2 (30000); CREATE OR REPLACE PACKAGE BODY SCMS_STRING_UTILSAsFUNCTION END_WITH (SR CS TRING VARCHAR2, --Source character string ENDCHAR VARCHAR2, --End character string IGNORECASE BOOLEAN --Ignore Case )RETURN BOOLEAN IS SRCLEN NUMBER (20) := LENGTH(SRCSTRING);ENDLEN NUMBER (20) := LENGTH(ENDCHAR);V_TOKEN_ARRAY TYPE_RMTS_ARRAYTYPE := TYPE_RMTS_ARRAYTYPE ();V_TOKEN_ARRAY1 TYPE_RMTS_ARRAYTYPE := TYPE_RMTS_ARRAYTYPE ();I NUMBER (20) := 1;TMP_CHAR VARCHAR(1);TMP_CHAR1 VARCHAR(1);BEGIN... END;END;/

输出

     
          CREATEOR REPLACE FUNCTION SCMS_STRING_UTILS.END_WITH (SRCSTRING VARCHAR2 /* source character string */, ENDCHAR VARCHAR2 /* End character string */, IGNORECASE BOOLEAN /* Ignore case */)RETURN BOOLEAN IS SRCLEN NUMBER (20) := LENGTH(SRCSTRING);ENDLEN NUMBER (20) := LENGTH(ENDCHAR);TYPE TYPE_RMTS_ARRAYTYPE IS VARRAY (1024) OF VARCHAR2 (30000);V_TOKEN_ARRAY TYPE_RMTS_ARRAYTYPE /*:= TYPE_RMTS_ARRAYTYPE()*/;V_TOKEN_ARRAY1 TYPE_RMTS_ARRAYTYPE /*:= TYPE_RMTS_ARRAYTYPE()*/;I NUMBER (20) := 1;TMP_CHAR VARCHAR(1);TMP_CHAR1 VARCHAR(1);BEGINEND;