plorasql支持多个EXCEPTION WHEN处理分支。用户在plorasql中可以预定义多个异常处理块，当程序执行过程中遇到了执行异常，执行会进入对应的异常处理模块。样例如下:

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
            

支持基于record的varray. 样例如下:

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