Oracle procedure out参数测试
测试procedure out参数:
1: SQL>create or replace procedure test_para_out(
2: o_code OUT varchar2(50),
3: o_mess OUT VARCHAR2(50)
4: )
5: is
6: ......
7: begin
8: ......
9: end;
1: SQL>set serveroutput on
2:
3: SQL>declare
4: o_code number;
5: o_mess varchar2(50);
6: begin
7: test_para_out(o_code,o_mess);
8: dbms.output.put_line(o_code||' '||o_mess);
9: end;
10: /