3 Replies Latest reply: Sep 9, 2011 2:05 PM by orafad RSS

    segmentation fault

    887243
      Hi,

      when i set the attribute in SQLSetStmtAttr to SQL_ATTR_ROW_ARRAY_SIZE then it gives segmentation fault
      at SQLFetchScroll on 64 bit rhel 6 unixODBC2.03 and oracle instant client 11g.


      Same call works fine on 32 bit rhel 5.


      Cal syntax ls


      SQLHSTMT hstmt;
      ....
      ..
      SQLINTEGER maxrow = 50000;
      SQLSetStmtAttr(htmst, SQL_ATTR_ROW_ARRAY_SIZE, (SQLPOINTER)maxrows, SQL_IS_INTEGER);


      ..
      ..
      ..
      SQLFetchScroll(hstmt, SQL_FETCH_NEXT, 0);


      skipped the intermediate function calls.
      if i comemt SQLSetStmtAttr the function SQLFetchScroll does not give segmentation fault.

      Here is the call stack of the core file generated
      bcoSetupPtrs () from /usr/lib/oracle/11.2/client64/lib/libsqora.so.11.1


      bcoReturnUserData () from /usr/lib/oracle/11.2/client64/lib/libsqora.so.11.1
      bcoCacheReturnData () from /usr/lib/oracle/11.2/client64/lib/libsqora.so.11.1
      bcoCacheFetchNext () from /usr/lib/oracle/11.2/client64/lib/libsqora.so.11.1
      bcoCacheFetch() from /usr/lib/oracle/11.2/client64/lib/libsqora.so.11.1
      bcoSQLScroll () from /usr/lib/oracle/11.2/client64/lib/libsqora.so.11.1
      bcoSQLFetchScroll () from /usr/lib/oracle/11.2/client64/lib/libsqora.so.11.1
      SQLFetchScroll() from /usr/lib/oracle/11.2/client64/lib/libsqora.so.11.1
      SQLFetchScroll(statement_handle=0xac97d0, fetch_orientation=1, fetch_offset=0) at SQLFetchScroll.c:277


      Awaiting your reply.


      Regards,

      Nithesh
        • 1. Re: segmentation fault
          orafad
          884240 wrote:
          when i set the attribute in SQLSetStmtAttr to SQL_ATTR_ROW_ARRAY_SIZE then it gives segmentation fault
          at SQLFetchScroll on 64 bit rhel 6 unixODBC2.03 and oracle instant client 11g.
          I believe you should report such issues via MOS (support.oracle.com), as forums is not generally monitored by Oracle nor meant as an official support channel.

          But basically, version 6 is not yet supported. (Without saying if that's related or no.)

          http://download.oracle.com/docs/cd/E11882_01/install.112/e16763/pre_install.htm#CHDFFBIF
          + for latest info, check Cert Matrix at MOS.
          • 2. Re: segmentation fault
            887243
            It says support version or later

            2.3.1 Operating System Requirements
            The following operating system versions (or later) are required for Oracle Database 11g Release 2 (11.2):


            and instant client 11.2.0.2.0 is a freeware and it does not provide customer support identifier to login to oracle.support


            Awaiting reply
            • 3. Re: segmentation fault
              orafad
              884240 wrote:
              It says support version or later
              Right. Later usually refers to "service packs" or "updates", not major versions. So if 5.2 is supported that tends to mean e.g. 5.3 is supported as well, but not 6.x.
              and instant client 11.2.0.2.0 is a freeware and it does not provide customer support identifier to login to oracle.support
              True. So one would need to have support contract for the overall Oracle Database product (which includes Database Client).