OCI and Input Arrays

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.com