在orcale存储过程里怎么返回一个数据集

[yezhizi]

在orcale存储过程里怎么返回一个数据集

[sunnysun67]

偶也想知道的

[0578]

用
open cursor for select * from tab;
返回

[yezhizi]

open cursor for select * from tab;

运行的时候会报错cursor must be declared ,

[saucer]

http://www.ondotnet.com/pub/a/dotnet/2002/12/16/multiresultsets_1202.html?page=2

http://builder.com.com/5100-6389-1049889.html

[yezhizi]

saucer(思归, .NET MVP),我有看过，但是还是不懂的，他这样声明，
CREATE OR REPLACE PACKAGE IssuesDBPKG AS
TYPE IssCur IS REF CURSOR;
PROCEDURE GetLookupValues (PriCur OUT IssCur,
StaCur OUT IssCur,
UsrCur OUT IssCur);
END IssuesDBPKG;

但是我怎么不可以呢
那我在oracle 里面怎么写呢