我用ref cursor返回存储过程的数据集,怎么抱错啊?CREATE OR REPLACE PACKAGE ABC AS
TYPE TYPE_CUR IS REF CURSOR; --定义游标变量用于返回记录集
PROCEDURE X(
V_CUR OUT TYPE_CUR --返回当前页数据记录
);
END ABC;
CREATE OR REPLACE PACKAGE BODY ABC AS
PROCEDURE X(
V_CUR OUT IS REF CURSOR
)
AS
BEGIN
OPEN V_CUR FOR SELECT * FROM XXX;
END X;
END ABC;
TYPE TYPE_CUR IS REF CURSOR; --定义游标变量用于返回记录集
PROCEDURE X(
V_CUR OUT TYPE_CUR --返回当前页数据记录
);
END ABC;
CREATE OR REPLACE PACKAGE BODY ABC AS
PROCEDURE X(
V_CUR OUT IS REF CURSOR
)
AS
BEGIN
OPEN V_CUR FOR SELECT * FROM XXX;
END X;
END ABC;
---
V_CUR OUT TYPE_CUR
TYPE TYPE_CUR IS REF CURSOR; --定义游标变量用于返回记录集
PROCEDURE X(
V_CUR OUT TYPE_CUR --返回当前页数据记录
);
END ABC;
CREATE OR REPLACE PACKAGE BODY ABC AS
PROCEDURE X(
V_CUR OUT TYPE_CUR
)
AS
BEGIN
OPEN V_CUR FOR SELECT * FROM XXX;
END X;
END ABC;可是这样还是不行噢
TYPE TYPE_CUR IS REF CURSOR; --定义游标变量用于返回记录集
PROCEDURE X(
V_CUR OUT TYPE_CUR --返回当前页数据记录
);
END ABC;
/
CREATE OR REPLACE PACKAGE BODY ABC AS
PROCEDURE X(
V_CUR OUT TYPE_CUR
)
AS
BEGIN
OPEN V_CUR FOR SELECT * FROM XXX;
END X;
END ABC;
Line # = 0 Column # = 0 Error Text = PLS-00923: 本机码编译失败: Visual C++ not found::Could not open registry key HKEY_LOCAL_MACHINE\SOFTWARE\MICROSOFT\VISUALSTUDIO\6.0\SETUP\MICROSOFT VISUAL C++:No error是不是还要装V C++