My question is how do I receive that array in Java. To start, I send 2 arrays, int and varchar2 as parameters in my pl/sql function. So, I'm only interested in the java program, the code below is what I started. Could anyone tell me if I'm doing it right. Thanks in advance for any help. StructDescriptor desc1=StructDescriptor.createDescriptor("RECTYPE",ora._con); STRUCT p1struct = new STRUCT(desc1, ora._con, p1obj1.toArray()); STRUCT p2struct = new STRUCT(desc1, ora._con, p1obj2.toArray());
What I'm doing is it correct. The code below what does it do? I don't know what it does exactly, could you please explain me. Thanks. ocs.registerOutParameter(1,OracleTypes.STRUCT,"RECTYPE"); ocs.registerOutParameter(2,OracleTypes.STRUCT,"RECTYPE"); ocs.registerOutParameter(3,OracleTypes.CURSOR);
Originally posted by Michael Pearson: Why do you want to move the data from the ResultSet to an Array? You already have a while loop that prints the ResultSet, so it would not take much to assign the ResultSet values to an Array.
[ April 25, 2002: Message edited by: bobby, morkos ]