17,377
社区成员
发帖
与我相关
我的任务
分享
CREATE OR REPLACE PROCEDURE test1
(
cv_1 IN OUT SYS_REFCURSOR,
cv_2 IN OUT SYS_REFCURSOR
)
AS
v_database NVARCHAR2(128);
BEGIN
open cv_1 for
SELECT *
FROM ( SELECT 字段1,字段2 FROM 表1 )
WHERE ROWNUM <= 1;
BEGIN
SELECT COUNT(*) INTO CNT FROM 表1 WHERE ROWNUM <= 1;
IF CNT = 0 THEN --no data
SELECT *
INTO v_database from (select 字段1 from 表2)
IF CNT > 0 THEN --have data
open cv_2 for SELECT v_database from dual;
else
操行别的操作
END IF;
END IF;
END;
if cv_1%notfound then
...
else
...
end if