This discussion is archived
1 Reply Latest reply: Jul 11, 2013 8:45 AM by Steve_Clamage RSS

Oracle singleton instance issue with OCIStmtFetch()

AbdulHarith Newbie
Currently Being Moderated


Hi,

 

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.

Legend

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