簡單實(shí)例:Oracle帶參數(shù)存儲(chǔ)過程的執(zhí)行:
SQL> create or replace procedure proc001
2 (a in varchar2,b out varchar2)
3 as
4 begin
5 b:= a;
6 end;
7 /
Procedure created
SQL> var c varchar2(10);
SQL> exec proc001('01',:c)
PL/SQL procedure successfully completed
c
---------
01
在java中調(diào)用存儲(chǔ)過程用的是call ps_name
x