3 Replies Latest reply on May 7, 2014 1:01 PM by James in Berkshire

    Sqldeveloper  4.0.0.13.80: fatal error viewing XMLTYPE table data using Thick driver

    James in Berkshire

      Problem: querying xmltype data from an aq table causes sqldeveloper to immediately crash.

       

      PC: Windows 7 Professional. 32-bit, 4gb RAM

       

      Sqldeveloper 4.0.0.13.80

      Java 1.7.0.45

      Instant Client: 11.2.0.3.0 (basic lite + sqlplus)

       

      Preferences:

      • Use Oracle Client: <Checked>
      • Configure:  Instant Client: file:/C:/Oracle/product/instantclient_11_2/
      • Use OCI/Thick Driver: <Checked>

       

      Connect to 11.2.0.3 database:

       

      select * from v$version;
      BANNER                                                                         
      --------------------------------------------------------------------------------
      Oracle Database 11g Release 11.2.0.3.0 - 64bit Production      
      

       

      Here's my table:

       

      desc AR_AQT_EXP_CACHE_UPDATE
      Name              Null     Type                
      ----------------- -------- ------------------- 
      Q_NAME                     VARCHAR2(30 CHAR)   
      MSGID             NOT NULL RAW(16 BYTE)        
      CORRID                     VARCHAR2(128 CHAR)  
      PRIORITY                   NUMBER              
      STATE                      NUMBER              
      DELAY                      TIMESTAMP(6)        
      EXPIRATION                 NUMBER              
      TIME_MANAGER_INFO          TIMESTAMP(6)        
      LOCAL_ORDER_NO             NUMBER              
      CHAIN_NO                   NUMBER              
      CSCN                       NUMBER              
      DSCN                       NUMBER              
      ENQ_TIME                   TIMESTAMP(6)        
      ENQ_UID                    VARCHAR2(30 CHAR)   
      ENQ_TID                    VARCHAR2(30 CHAR)   
      DEQ_TIME                   TIMESTAMP(6)        
      DEQ_UID                    VARCHAR2(30 CHAR)   
      DEQ_TID                    VARCHAR2(30 CHAR)   
      RETRY_COUNT                NUMBER              
      EXCEPTION_QSCHEMA          VARCHAR2(30 CHAR)   
      EXCEPTION_QUEUE            VARCHAR2(30 CHAR)   
      STEP_NO                    NUMBER              
      RECIPIENT_KEY              NUMBER              
      DEQUEUE_MSGID              RAW(16 BYTE)        
      SENDER_NAME                VARCHAR2(30 CHAR)   
      SENDER_ADDRESS             VARCHAR2(1024 CHAR) 
      SENDER_PROTOCOL            NUMBER              
      USER_DATA                  XMLTYPE()           
      USER_PROP                  ANYDATA()           
      

       

      Then run a simple query on user_data:

       

      select user_data from AR_AQT_EXP_CACHE_UPDATE;
      

       

      Crash occurs immediately, Sqldeveloper vanishes.

       

      observations:

      1. doesn't crash if "Use OCI/Thick driver" is unchecked.

      2. Changing "Display Struct Value In Grid" doesn't change the behaviour (i.e. crashes with thick driver, works otherwise).