E
erbird
Unregistered / Unconfirmed
GUEST, unregistred user!
我在oracle建了一个存储过程，功能是查询返回一个数据集，在delphi中用BDE调用是没问题的，
用ado的adodataset调用也是没问题的，现在我要用adoStoredProc调用，不行。用ado调用时
用的是Microsoft OLE DB Provider for Oracle,改用Oracle Provider for OLE DB也不行，
请问是怎么回事？？下面是我的存储过程：
create table test( a number,b number);
insert into test values(111,222);
insert into test values(11,22);
insert into test values(1,2);
CREATE OR REPLACE PACKAGE TypeDefine
AS
TYPE Cursor_Test IS REF CURSOR RETURN Test%ROWTYPE;
END;
CREATE OR REPLACE PROCEDURE sp_test
(resultData IN OUT TypeDefine.Cursor_Test)
AS
BEGIN
OPEN resultData FOR
SELECT a,b from test;
END;
用ado的adodataset调用也是没问题的，现在我要用adoStoredProc调用，不行。用ado调用时
用的是Microsoft OLE DB Provider for Oracle,改用Oracle Provider for OLE DB也不行，
请问是怎么回事？？下面是我的存储过程：
create table test( a number,b number);
insert into test values(111,222);
insert into test values(11,22);
insert into test values(1,2);
CREATE OR REPLACE PACKAGE TypeDefine
AS
TYPE Cursor_Test IS REF CURSOR RETURN Test%ROWTYPE;
END;
CREATE OR REPLACE PROCEDURE sp_test
(resultData IN OUT TypeDefine.Cursor_Test)
AS
BEGIN
OPEN resultData FOR
SELECT a,b from test;
END;