C / C++ / MFC

<br />
CREATE OR REPLACE PACKAGE BODY UNICORN.SAL2UNI<br />
AS <br />
PROCEDURE SAL2UNI_GETPLANS(PLAN_ID IN OUT PK_PLAN_CUR)<br />
AS<br />
BEGIN<br />
IF NOT PLAN_ID%ISOPEN<br />
THEN<br />
OPEN PLAN_ID FOR SELECT PLANID from PK_PLAN where STOPDATE >= SYSDATE; <br />
END IF;<br />
END;<br />
<br />
PROCEDURE SAL2UNI_GETSERVICEINSTANCES(SERVINST IN VARCHAR2,SVCMIG OUT CUR_GET_SI)<br />
IS<br />
PICCODE VARCHAR2(1);<br />
COMPANYID VARCHAR(5);<br />
OCPPRODUCT VARCHAR(5);<br />
BEGIN<br />
PICCODE := 'P';<br />
COMPANYID := '11';<br />
OCPPRODUCT := 'OCP';<br />
<br />
IF NOT SVCMIG%ISOPEN<br />
THEN<br />
OPEN SVCMIG FOR<br />
select distinct<br />
accountno,<br />
serviceno,<br />
status,<br />
startdate,<br />
stopdate,<br />
reasonid,<br />
PICCODE,<br />
startdate,<br />
COMPANYID,<br />
OCPPRODUCT,<br />
cic,<br />
null,<br />
null,<br />
null,<br />
null<br />
from CC_AccountService<br />
where serviceno=SERVINST;<br />
END IF;<br />
END;<br />
<br />
END SAL2UNI;<br />

<br />
.<br />
.<br />
.<br />
Statement *stmt = con->createStatement <br />
("BEGIN SAL2UNI.SAL2UNI_GETSERVICEINSTANCES(:v1, :v2); END;");<br />
<br />
stmt->setString(1,"9721234567");<br />
stmt->registerOutParam (2, OCCICURSOR);<br />
int updateCount = stmt->executeUpdate ();<br />
<br />
// updateCount returns 1<br />
<br />
ResultSet *rs = stmt->getCursor(2);<br />
???<br />
.<br />
.<br />