1.Oracle中的异常处理:
exception
when others then
异常的处理
end
例如:
create or replace procedure sp_query_test(p_id in int,
p_errorcode in out int,
p_errormsg in out varchar2)
is
p_sql varchar(3000);
begin
p_errorcode:=0;
p_errormsg :='ok';
p_sql:='insert into test (id,iname,icode,iaddr) select name,code,addr from test2 whe