Hi, I have created an Oracle Object which has some data members as VARRAYs . Inside my Java program , I am retrieving data from the table and assigning the values to the local variables. For ex.. Suppose my Object(Oracle) name is Person which is a column Object in the Table Tab1 and has a data member Accounts which is a VARRAY of VARCHAR2(100) Now in my Java program ResluSet rs=staement.executeQuery("select Person.Accounts as obj from Tab1");
But how to retrieve the data in the fileds which are VARRAYS , even though I write get and set methods in the Oracle Object what I should return from them and how to assign them to the String arrays...
Hi, You can use the Oracle extentions of jdbc to achieve this. ARRAY array = ((OracleResultSet)rs).getARRAY (1); Using array.getArray(), you can populate an array and then use that. Note that in the select statement you should select the varray. Hope this helps, Ram
Joined: Sep 25, 2000
Thanks Ram, I solved that problem using getARRAY() method, the problem was I have n't placed the drivers properly.. Any how thanks for the reply....