存储过程如何返回一个结果集

create or replace package test
as
type refcursor is ref cursor;
end;

create or replace procedure testcursor(p_rst out test.refcursor)
as
begin
open p_rst for
select * from table;
end;

search

SQL Server和Oracle是有区别的。在oracle中返回数据集可以这样写：
CREATE OR REPLACE PACKAGE CX_InfoPhonePack
AS
TYPE curPhoneCode IS REF CURSOR RETURN YW_Info%ROWTYPE;
END;
/
CREATE OR REPLACE PROCEDURE CX_InfoPhoneProc
(iPhoneCode YW_Info.PHONECODE%type,cPhoneCode OUT CX_InfoPhonePack.curPhoneCode)
AS
BEGIN
OPEN cPhoneCode FOR
SELECT *
FROM YW_Info
WHERE (PicID>0) and (PhoneCode Like '%'||iPhoneCode||'%');
END;
/