SAP Knowledge Base Article - Preview

3001439 - SAP / Sybase ASE/CIS . . . Unable to select from a table with a text column

Symptom

  • Unable to select from a table with a text column associated with proxy_table / remote server existing table thru SAP / Sybase DC / ECDA / dcoracle in remote oracle db server
     select against proxy_table with clob column in oracle
       ... hangs indefinitely ... ? ? ?
        with
         00:000#:00000:000##:YYYY/MM/DD 24:MM:SS.ms server  TXTABORT, spid ##: deallocating cursor '<cursor_nm>'

     


Read more...

Environment

  • linux SAP / Sybase . . . DC / ECDA / dcoracle . . . DirectConnect for Oracle
       DirectConnect-Oracle/15.7 SP05/P-EBF28959/Enterprise Linux/OS 2.6.18-398.el5/15/OPT/26-Mar-2019 23:57:48
  • linux ASE
       Adaptive Server Enterprise/16.0 SP03 PL08 HF1/EBF 29398 SMP/P/x86_64/SLES 11.1/ase160sp03pl08x/3777/64-bit/FBO/Tue Mar 31 20:32:47 2020

Product

Sybase Adaptive Server Enterprise 15.0

Keywords

ASE Text Column 817607 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.