Re: [OCI][9i]How can a fetch freeze an application ?

Herode wrote:
> Gentlemen,
>
> I have an OCI-based code making all the Oracle calls for the main
> application. All that stuff works, except in one specific environment.
> In this case, the app freezes on the first call to
> ::OCIStmtFetch2(...).
>
> The select * from dba_blockers and the SQL traces do not evidence any
> lock. Anyway, even if the app is multithreaded (and the OCI environment
> initialized in OCI_THREADED mode), I am the only user connected to the
> database for this test. Moreover, the blocking fetch follows the
> execute of a simple select query, not even a select for update.
>
> I wonder if the fact that the app is started as an XP Service has
> something to do with this lock ? Are there any communication pitfalls
> in this case for OCI ?
>
> I'm stuck with this bug for some days now, any help or idea will be
> greatly appreciated !
> Best regards,
> C.
>

 >In this case, the app freezes on the first call to  >::OCIStmtFetch2(...).

Can you try fetching using OCIStmtExecute(..) itself ? Set the iters parameter to a non-zero value ( of course, you must have the define buffers in place before the call).

If this works, you can be sure that theres a problem with your OCIStmtFetch2(..) call.

Rgds.
Amogh Received on Tue Apr 25 2006 - 06:39:41 CDT