CREATE OR REPLACE PROCEDURE P_5_5 AS
TYPE nested_type IS TABLE OF VARCHAR2(15); -- 定义嵌套表类型
TYPE varray_type IS VARRAY(50) OF INTEGER;
TYPE associative_array_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
V1 nested_type;
V2 varray_type;
V3 associative_array_type;
V11 v1%TYPE;
V22 v2%TYPE;
V33 V3%TYPE;
BEGIN
GBase 8s PL/SQL手册
南大通用数据技术股份有限公司
- 63 -
NULL;
END;