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: to - 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)


OCI program hangs on


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 running on Windows 2003. However, the same testcase worked against an Oracle Database version running on Oracle Solaris.


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