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