CREATE OR REPLACE PACKAGE xpp_DB170 AS
TYPE t_RetDataSet IS REF CURSOR;
END xpp_DB170;
/
CREATE OR REPLACE PROCEDURE P_TotalByIVR(
rCursor IN OUT xpp_DB170.T_RetDataSet
)
AS
BEGIN
OPEN rCursor FOR SELECT
NVL(SUM(AnsNum+FailNum),0) AS ID1
FROM tAutoInfo
WHERE LogDate >= TRUNC(tMaxDate)
RETURN;
EXCEPTION
WHEN OTHERS THEN
RETURN;
END P_TotalByIVR;
/
huawei--创建游标,游标使用
最新推荐文章于 2022-11-17 17:36:24 发布