This discussion is archived
1 Reply Latest reply: Jun 6, 2013 10:27 AM by Steve_Clamage RSS

ORA-32102: invalid OCI handle

1013214 Newbie
Currently Being Moderated
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 Pro
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points