OCI and Input Arrays
From: Pete2003 <member21962_at_dbforums.com>
Date: Tue, 04 Feb 2003 11:46:29 +0000
Message-ID: <2479425.1044359189_at_dbforums.com>
Date: Tue, 04 Feb 2003 11:46:29 +0000
Message-ID: <2479425.1044359189_at_dbforums.com>
Hi,
C++:
I have a simple C++ array:
char szStrings[3][100];
strcpy(szStrings[0], "Hello"); strcpy(szStrings[1], "There"); strcpy(szStrings[2], "World");
Oracle:
arrType is a table type of varchar2(100)
I have a stored procedure:
Procedure testProc( inArr IN arrType )
DECLARE
nIdx NUMBER;
BEGIN
FOR nIdx IN 0..2 LOOP
INSERT INTO test_table VALUES(inArr(nIdx));
END LOOP;
END
So to call it in C++ (OCI) I would call it with sql statement:
char *sql = "BEGIN testProc(:myArray); END;";
now I need to know how and what do I bind to get this to work ... could anybody please give me an example ....
Thanks
-- Posted via http://dbforums.comReceived on Tue Feb 04 2003 - 12:46:29 CET