CREATE OR REPLACE PACKAGE p_test
AS
TYPE myrctype IS REF CURSOR;
PROCEDURE a ( p_c OUT myrctype);
END p_test;
/CREATE OR REPLACE PACKAGE BODY p_test
AS
PROCEDURE a ( p_c OUT myrctype)
IS
BEGIN
OPEN p_c FOR select COL1,COL2 from TABLE_NAME;
END A;
END p_test;
/
AS
TYPE myrctype IS REF CURSOR;
PROCEDURE a ( p_c OUT myrctype);
END p_test;
/CREATE OR REPLACE PACKAGE BODY p_test
AS
PROCEDURE a ( p_c OUT myrctype)
IS
BEGIN
OPEN p_c FOR select COL1,COL2 from TABLE_NAME;
END A;
END p_test;
/
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货