oracle存储过程

实例一：

create or replace procedure test1(vi_a in varchar2,vi_b in varchar2,vo_return out varchar2) is

v_sql varchar2(2000);

v_count number;

begin

    select count(1) into v_count from dual;

    v_sql：=‘ where id=:1 and name=:2’；

exectue immediate v_sql using vi_a,vi_b;

if v_count is null then

else

end if;

commit;

Exception

    when others then

        rollback;

vo_return:='';

commit;

end;

实例二： 自定义数组类型

create or replace Type test_array as varray(9999999) of Nvarchar2(1024)

存储过程中循环的另一种写法：

for I in 1 .. vi_array.count loop

    if I / 1000 = 0 then

        commit;

    end if;

end loop;

commit;