create or replace procedure test_1 ( as_id in varchar2,
as_name in varchar2,
ai_retnum out number,
as_retstr out varchar2,
) is
这样利用出参来返回值
as_name in varchar2,
ai_retnum out number,
as_retstr out varchar2,
) is
这样利用出参来返回值
s2 in number,
ret_1 out number,
ret_2 out varchar2) isBegin
insert into my_test_tab values(s1,s2,s3);
ret_1=23;
ret_2='ooo';End testp1;
http://blog.csdn.net/dinya2003/archive/2004/11/05/169146.aspx
SQL> exec testp1;begin testp1; end;ORA-06550: 第 1 行, 第 7 列:
PLS-00306: 调用 'TESTP1' 时参数数量或类型错误
ORA-06550: 第 1 行, 第 7 列:
PL/SQL: Statement ignored
create or replace procedure testp1(ret_2 out Varchar2) Is
begin
ret_2 := 'ddd2';
End testp1;