1 Reply Latest reply: Jul 8, 2014 11:52 AM by Joe Weinstein-Oracle RSS

    Major issue with latest OJDBC drivers

    9316b32a-5636-4e3b-b2f7-8a93f47ed26a

      Hi ,

      We are facing one major issue after server up gradation where we upgraded -

      Oracle 10g to -- Oracle 11.2.0.4 G

      JDK 1.5 to  -- JDK 1.7


      And as per oracle recommendation we should use ojdbc6.jar for JDK 7

      But after using latest oracle driver(ojdbc5 or ojbc6 or ojbc7.jar ) , Oracle.sql.array.getArray() is not working properly .

      Basically I am using Oracle.sql.array.getArray() function to retrieve array which is returning - [0]: "???"   now

      1. i.e. latest driver is unable to retrieve the xml file and returning - [0]: "???"

      but same is working fine with ojdbc14.jar implementation  but not working with latest implementation of ojdbc5.jar or ojdbc6.jar .

      so main culprit is Oracle.sql.array.getArray() function which is not giving correct  value if we use OJDBC5 ,6 ojdbc7.jar .

      in Database i am executing below SQL query

      SELECT message_content FROM cmgp_incoming_xml_content where message_content_ID = 123456 ;

       

      Here message_content is user define data type of CBUF_VARRAY Please find below script for CBUF_VARRAY

      CREATE OR REPLACE TYPE AQ_ADM."CBUF_VARRAY2" AS VARRAY(1000) OF VARCHAR2(32000).

      Request you to please help us on this  ,why latest implementation of  ojdbc5.jar or ojdbc6.jar is not supporting  Oracle.sql.array.getArray().

       

      Regards,
      -Shirish