达梦数据库数组使用

CREATE or REPLACE PROCEDURE RTU_STATUS_CHANGE(startTimeStr IN VARCHAR, endTimeStr IN VARCHAR)
AS
declare 
	TYPE ccc IS ARRAY int[];
	intArray ccc;
BEGIN 
	intArray = NEW int[3];
	--intArray[0] = 0;
	intArray[1] = 1;
	intArray[2] = 2;
	intArray[3] = 3;
	delete from test;
	insert into test(id) values(intArray[3]);
END ;

注意数组元素下标从1开始。