存储过程使用数组参数

--创建类型CREATE OR replace TYPE varray_list AS varray(10) OF varchar2(50);--创建存储过程CREATE OR replace PROCEDURE show_list(p_varlist IN varray_list)ISi number;temp varchar2(20);BEGINFOR x IN 1..p_varlist.count loopdbms_output.put_line(p_varlist(x));END loop;END show_list;--调用存储过程set serveroutput on;exec show_list(myvarray_list(&＃39;zsh1&＃39;,&＃39;zsh2&＃39;,&＃39;zsh3&＃39;,&＃39;zsh4&＃39;));