Support multiple EXCEPTION WHEN branches in plorasql. Users can predefine multiple exception handling blocks in plorasql, when the program execution process encounters an execution exception, the execution will enter the corresponding exception handling module. The usage is described below:

create table t_uniq(a int primary key);

CREATE OR REPLACE PROCEDURE pro100 is
	a int:=0;
BEGIN  
	insert into t_uniq values(1);
	insert into t_uniq values(1);
	a:=10/0;
EXCEPTION
	when unique_violation then
		dbms_output.put_line('unique_violation');
	when division_by_zero then
		dbms_output.put_line('division_by_zero');
	when others then
		dbms_output.put_line(sqlcode||' '||sqlerrm);
END;  
/

call pro100;
unique_violation
CALL
            

Support varray based on record. The usage is described below:

CREATE OR REPLACE PROCEDURE pro100 is
	type test_rc_type is record(a int,b varchar,d date);
	type va_type is varray(3) of test_rc_type;
	v1 va_type := va_type();
BEGIN  
	v1(0).a = 11+88;
	v1(1).b = 'ab'||'cd';
	v1(2).d = to_date('2022-01-01','yyyy-mm-dd') + interval '1 day';
	
	dbms_output.put_line(v1(0).a || ',' || v1(1).b || ',' || v1(2).d);
END;  
/

call pro100;
99,abcd,2022-01-02 00:00:00
CALL