SQL> var names varchar2;
SQL> exec PKG_REPAIR_ZTB.PRO_TEST(:names,'','');
PL/SQL procedure successfully completed
names
---------
1
SQL> call PKG_REPAIR_ZTB.PRO_TEST(:names,'','');
Method called
names
---------
1
Oracle执行存储过程
一、带参数
如上代码所示。
二、不带参数
call 存储过程([参数1,参数2]) []内容省略.