I have an Oracle SP that returns a Array.
Now, I am trying to retrieve the elements in that array using the following code snippet....but i am facing a java.lang.ClassCastException....
can somebody help me out with this???
i got this code from a tutorial......
cstmt1.registerOutParameter(4, OracleTypes.ARRAY,"PROPLIST");
cstmt1.executeUpdate();
ARRAY propValues = (ARRAY)cstmt1.getArray(4);
String[] values = (String[]) propValues.getArray();
for( int i = 0; i < values.length; i++ )
{
System.out.println( "row " + i + " = '" + values + "'" );
}