我给你一个例子,你的问题可能是VB.net有缺陷,我用C#就可以
CREATE OR REPLACE PACKAGE Personality
IS
cursor c1 IS
SELECT First_Name, Last_Name FROM People;
TYPE PeopleCur IS REF CURSOR RETURN c1%rowtype;
PROCEDURE GetNames
(
pGender IN VARCHAR2,
PeopleCursor in out PeopleCur
);
END Personality;
CREATE OR REPLACE PACKAGE BODY Personality
AS
PROCEDURE GetNames
(
pGender IN VARCHAR2,
PeopleCursor in out Peoplecur
)
IS
begin
OPEN PeopleCursor FOR
SELECT First_Name, Last_Name FROM People WHERE gender = pGender;END GetNames;
END Personality;
CREATE OR REPLACE PACKAGE Personality
IS
cursor c1 IS
SELECT First_Name, Last_Name FROM People;
TYPE PeopleCur IS REF CURSOR RETURN c1%rowtype;
PROCEDURE GetNames
(
pGender IN VARCHAR2,
PeopleCursor in out PeopleCur
);
END Personality;
CREATE OR REPLACE PACKAGE BODY Personality
AS
PROCEDURE GetNames
(
pGender IN VARCHAR2,
PeopleCursor in out Peoplecur
)
IS
begin
OPEN PeopleCursor FOR
SELECT First_Name, Last_Name FROM People WHERE gender = pGender;END GetNames;
END Personality;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货