We are facing one major issue after server up gradation where we upgraded -
Oracle 10g to -- Oracle 22.214.171.124 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 - : "???" now
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().
Hi. It sounds like a driver-only issue. I'd suggest opening a support case, with a standalone example (no weblogic involved)