1、调用procedure:
v_sql := 'Begin pkg_name.procedure_name(:in_v1, :in_v2, :out_v1, :out_v2); End;' ;
EXECUTE IMMEDIATE v_sql using in in_value1,in in_value2,out out_value1,out out_value2;
2、调用function(带返回值)
v_sql := 'call pkg_name.func_name(:1,:2) into :3';
EXECUTE IMMEDIATE v_sql using in in_value1,in in_value2,out out_value;