Program Hangs Getting Clob When Using Scrollable Cursor With OCIStmtFetchOCIStmtFetch2 (Doc ID 1325443.1)

Last updated on JULY 05, 2017

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 10.2.0.4 - Release: 10.2 to 10.2
Microsoft Windows (32-bit)
***Checked for relevance on 31-May-2011***

Windows XP Professional Service Pack 2
Microsoft Visual C++ .NET 69461-270-0000007-18731 (MS Dev Env, 2003 version)

Symptoms

OCI program hangs on

OCIStmtFetchOCIStmtFetch2

while fetching last-to-first using a SCROLLABLE CURSOR. The problem is occurring at the following line of code:

status = OCIStmtFetchOCIStmtFetch2(stmthp, errhp, (ub4) 1, (ub2) OCI_FETCH_LAST,
(sb4) 0, OCI_DEFAULT) ;

This only reproduces against an Oracle Database running on Windows. In testing it, failed against a Oracle Database version 10.2.0.3.0 running on Windows 2003. However, the same testcase worked against an Oracle Database version 10.2.0.3.0 running on Oracle Solaris.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms