call store-p的写法
PROCEDURE xxx_SEARCH (
namein varchar2,
email in varchar2,
O_out_info out SYS_REFCURSOR,
o_total_cnt out int
)
variable o_out_info REFCURSOR;
variable o_total_cnt NUMBER;
call xxx_PKG.xxx_SEARCH ('Jennie','Jennie.qq.com',:o_out_info,:o_total_cnt);
print o_total_cnt;
print o_out_info;
浙公网安备 33010602011771号