1 Reply Latest reply on Jun 6, 2013 5:27 PM by Steve.Clamage-Oracle

    ORA-32102: invalid OCI handle

    1013214
      Hi Team,

      I am facing an error in our oracle OCCI application.

      Error:
      ORA-32102: invalid OCI handle

      code:
      ========================================================
      Statement *stt;
      char *dq = new char[1024];
      in status;
      ....
      ....
      ....
      sprintf(dq,"insert into......", table);

      stt = con->createStatement();
      status = stt->executeUpdate(dq);
      con->terminateStatement(stt);

      NOTE: It is in a loop and thread will check the queue and pick file to do summarization...

      Query is like "Inser into table (select ....summary query)".
      ========================================================

      It is multi-threaded application and I am creating env with OBJECT. above code is part of thread action procedure.

      Please help me on the same. thanks in advance for your reply.

      Regards,
      Srithar
        • 1. Re: ORA-32102: invalid OCI handle
          Steve.Clamage-Oracle
          This forum is about general programming in C, C++ and Fortran, and about details of using the Solaris Studio suite of compilers and programming tools.

          Questions about Oracle database programming are more likely to get an answer in a database programming forum. A list of forums is here:
          https://forums.oracle.com/forums/category.jspa?categoryID=18