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;
posted @ 2024-05-19 14:11  JennieRainbow  阅读(5)  评论(0)    收藏  举报