i am folowing a singletom pattern in my VC++ application were only one Oracle instance is created and it is being used through out the application. The OCIStmtFetch() is used twice in the application and when the OCIStmtFetch() is invoked for the second time it returns a OCI_NO_DATA condition. But when i created a new instance of Database use it to invoked the OCIStmtFetch() for the second time it gives a proper result. please can some one help me on why the singleton DBinstance is causing issue with the OCIStmtFetch() for the second time.
This forum is about general programming in C, C++, and Fortran, and specifically about using the Oracle Solaris Studio suite of programming tools. Since your question is about using VC++ with Oracle database, you are not likely to get a helpful answer here. (Oracle Solaris Studio is not available on Windows.)
I suggest you try an Oracle database programming forum. Start here: