0 Replies Latest reply on Mar 14, 2014 10:30 PM by user12089729

    hang in OCIStmtFetch

    user12089729

      Job hangs in OCIStmtFetch whan reading CLOB data from oracle whose length exceeds more than certain length and if data is multibyte.

       

      Oracle server installed on AIX 6.1 and version is 11.2.0.4

      Oracle client is on Windows 64-bit and its version is 11.2.0.4

       

      Using same oracle client version and using Oracle installed on LINUX or Windows issue is not reproducible.

       

      Here stack trace:

      Child-SP RetAddr           Call Site

      00000000`0f6e6958 000007fe`fd52f231 ntdll!NtWaitForSingleObject+0xa

      00000000`0f6e6960 000007fe`fd5316a8 mswsock!WSPStartup+0x69a1

      *** ERROR: Symbol file could not be found.  Defaulted to export symbols for ws2_32.dll -

      00000000`0f6e69e0 000007fe`ff8621a9 mswsock!WSPStartup+0x8e18

      *** ERROR: Symbol file could not be found.  Defaulted to export symbols for orantcp11.dll -

      00000000`0f6e6ad0 00000000`0d5b2254 ws2_32!WSARecv+0x169

      00000000`0f6e6b50 00000000`0d5a9917 orantcp11!nttini+0x4950

      *** ERROR: Symbol file could not be found.  Defaulted to export symbols for oran11.dll -

      00000000`0f6e6bd0 00000000`0d22b4dd orantcp11+0x19917

      00000000`0f6e6da0 00000000`0d22eac7 oran11!nsbnt+0xc1dd

      00000000`0f6e7430 00000000`0d1474cc oran11!nsbrecv+0x43

      *** ERROR: Symbol file could not be found.  Defaulted to export symbols for oracommon11.dll -

      00000000`0f6e7480 00000000`0b744d15 oran11!nioqrc+0x1ec

      00000000`0f6e7670 00000000`0d16ca7c oracommon11!ttcdrv+0x613

      *** ERROR: Symbol file could not be found.  Defaulted to export symbols for OraClient11.Dll -

      00000000`0f6e7fd0 00000000`0b0f1aba oran11!nioqwa+0x38

      00000000`0f6e8010 00000000`0b0d8659 OraClient11!upicui2+0x9a8

      00000000`0f6eab70 00000000`0b02d8e8 OraClient11!upirtrc+0x75

      00000000`0f6eabe0 00000000`0afa45d3 OraClient11!kpurcsc+0x96

      00000000`0f6eac50 00000000`0afa6397 OraClient11!kpufGetRcvInfo+0x1e6d

      00000000`0f6ed890 00000000`0ae37e6d OraClient11!kpufGetRcvInfo+0x3c31

      *** ERROR: Symbol file could not be found.  Defaulted to export symbols for oci.dll -

      00000000`0f6ed990 00000000`0ad24809 OraClient11!OCIStmtFetch+0x1b

      00000000`0f6ed9d0 00000001`801128c9 oci!OCIStmtFetch+0x91