Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Posts
    6

    Question Unanswered: 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

  2. #2
    Join Date
    Jan 2004
    Posts
    4

    Re: OCI and Input Arrays

    Hello,

    I have a similar problem, did you have resolve it ?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •