下面这个函数,怎么能调用并取得游标类型的返回值
---------------------------------
test1:
---------------------------------
RETURN pkg_test.myrctype
AS
rc pkg_test.myrctype;
BEGIN
OPEN rc
FOR
SELECT * FROM table1; RETURN rc;
END;
---------------------------------
test1:
---------------------------------
RETURN pkg_test.myrctype
AS
rc pkg_test.myrctype;
BEGIN
OPEN rc
FOR
SELECT * FROM table1; RETURN rc;
END;
_RecordsetPtr pRst=pCmd.Execute;
Cmd1->ActiveConnection = Conn1;
Cmd1->CommandText = bstrSP;
Cmd1->CommandType = ADODB::adCmdUnknown;//adCmdStoredProc;
Rs1 = Cmd1->Execute(&vtEmpty, &vtEmpty2, ADODB::adCmdUnknown );//还是不行!!!
Error number: 80040e51 Provider cannot derive parameter information and SetParameterInfo has not been called.
Cmd1->CommandText = bstrSP;
Cmd1->CommandType = ADODB::adCmdStoredProc;
//Cmd1->Parameters->Refresh();Rs1 = Cmd1->Execute(&vtEmpty, &vtEmpty2, ADODB::adCmdStoredProc );Error number: 80040e14 ORA-06550: 第 1 行, 第 7 列:
PLS-00221: 'test1' 不是过程或尚未定义
ORA-06550: 第 1 行, 第 7 列:
Cmd1->CommandText = bstrSP;
Cmd1->CommandType = ADODB::adCmdUnknown ;
//Cmd1->Parameters->Refresh();Rs1 = Cmd1->Execute(&vtEmpty, &vtEmpty2, ADODB::adCmdUnknown );Error number: 80040e14 ORA-00900: 无效 SQL 语句
Cmd1->CommandText = bstrSP;
Cmd1->CommandType = ADODB::adCmdStoredProc;//Cmd1->Parameters->Refresh();Rs1 = Cmd1->Execute(NULL,NULL,adCmdStoredProc );
在oracle环境下也测试过的
建议搜索一下以前的帖子。