create or replace procedure pro_test(in int4,in text,out int4,out int4) return void as
declare
v_clsid alias for $1;
v_insertqry alias for $2;
v_oid alias for $3;
v_vid alias for $4;
exesql text;
begin
.
.
.
end;
在以上声明块中 v_clsid alias for $1;是什么意思呢
declare
v_clsid alias for $1;
v_insertqry alias for $2;
v_oid alias for $3;
v_vid alias for $4;
exesql text;
begin
.
.
.
end;
在以上声明块中 v_clsid alias for $1;是什么意思呢
create or replace procedure pro_test(v_clsid in int4,v_insertqry in text,v_oid out int4,v_vid out int4) return void as
前提是:你自创一套ORACLE