存储过程如下:
create or replace procedure SP_TEST(retval out int, pCursor out sys_refcursor)
AS
BEGIN
OPEN pCursor FOR
SELECT CUST_CODE, REMARK FROM CUSTOMER ORDER BY CUST_CODE;
retval := 0;
END SP_TEST;静态调用:
EXEC SQL INCLUDE SQLCA;
EXEC SQL INCLUDE SQLDA;
EXEC SQL BEGIN DECLARE SECTION;
int retval;
SQL_CURSOR scur;
EXEC SQL END DECLARE SECTION;EXEC SQL ALLOCATE :scur;
EXEC SQL EXECUTE BEGIN SP_TEST(:retval,:scur); END; END-EXEC;
EXEC SQL FETCH :scur INTO :llCustCode,:szRe;怎么实现动态调用?
create or replace procedure SP_TEST(retval out int, pCursor out sys_refcursor)
AS
BEGIN
OPEN pCursor FOR
SELECT CUST_CODE, REMARK FROM CUSTOMER ORDER BY CUST_CODE;
retval := 0;
END SP_TEST;静态调用:
EXEC SQL INCLUDE SQLCA;
EXEC SQL INCLUDE SQLDA;
EXEC SQL BEGIN DECLARE SECTION;
int retval;
SQL_CURSOR scur;
EXEC SQL END DECLARE SECTION;EXEC SQL ALLOCATE :scur;
EXEC SQL EXECUTE BEGIN SP_TEST(:retval,:scur); END; END-EXEC;
EXEC SQL FETCH :scur INTO :llCustCode,:szRe;怎么实现动态调用?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货