Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Calling stored procedures in c++ via odbc
I have the following done in sql*plus
DROP PACKAGE ODBCRefCus;
CREATE PACKAGE ODBCRefCus AS
TYPE firstname_cus IS REF CURSOR;
TYPE familyname_cus IS REF CURSOR;
TYPE address_cus IS REF CURSOR;
TYPE telno_cus IS REF CURSOR;
PROCEDURE spEmpCus(Firstname IN OUT firstname_cus, Familyname IN OUT
familyname_cus, Address IN OUT address_cus, Telno IN OUT telno_cus,
comp IN
VARCHAR2);
END;
/
CREATE PACKAGE BODY ODBCRefCus AS
PROCEDURE spEmpCus(Firstname IN OUT firstname_cus, Familyname IN OUT
familyname_cus, Address IN OUT address_cus, Telno IN OUT telno_cus,
comp IN
VARCHAR2)
AS
BEGIN IF NOT Firstname%ISOPEN THEN OPEN Firstname for SELECT firstname FROM customers WHERE firm = comp; END IF; IF NOT Familyname%ISOPEN THEN OPEN Familyname for SELECT familyname FROM customers WHERE firm = comp; END IF; IF NOT Address%ISOPEN THEN OPEN Address for SELECT address FROM customers WHERE firm = comp; END IF; IF NOT Telno%ISOPEN THEN OPEN Telno for SELECT telno FROM customers WHERE firm = comp; END IF; END;
NB: I do use oracle9i, c++builder6
I'm quite in need of your help.
Regards,
Harp
Received on Thu Feb 10 2005 - 03:51:20 CST