我想定义个存储过程返回结果集,可是老是有问题,以下是存储过程的定义: CREATE OR REPLACE PACKAGE PKG_REFCURSOR ISTYPE MYCURSOR IS REF CURSOR;END PKG_REFCURSOR;
create or replace PROCEDURE PR_KHLB_TEST
(
khlb_out out PKG_REFCURSOR.MYCURSOR
)
IS
begin
open khlb_out for
select khlb from t_xt_khlb where bh='1';
end PR_KHLB_TEST;
create or replace PROCEDURE PR_KHLB_TEST
(
khlb_out out PKG_REFCURSOR.MYCURSOR
)
IS
begin
open khlb_out for
select khlb from t_xt_khlb where bh='1';
end PR_KHLB_TEST;
TYPE MYCURSOR IS REF CURSOR;
procedure TEST(khlb_out out MYCURSOR);
END PKG_REFCURSOR;
CREATE OR REPLACE PACKAGE body PKG_REFCURSOR IS
procedure TEST(khlb_out out MYCURSOR)
is
begin
open khlb_out for
select khlb from t_xt_khlb where bh='1';
end;
END PKG_REFCURSOR;
CREATE OR REPLACE PACKAGE PKG_REFCURSOR IS
TYPE MYCURSOR IS REF CURSOR;
procedure TEST(khlb_out out MYCURSOR);
END ; CREATE OR REPLACE PACKAGE body PKG_REFCURSOR IS
procedure TEST(khlb_out out MYCURSOR)
is
begin
open khlb_out for
select * from latn ;
end;
END ;