Accessing SQL Object type

[Srikanth Basa]

I have to access SQL object types. One approach I know is to implement the SQLData interface and create classes for the type objects.

Is there any other mechanism to access ?

One simple way I see is using STRUCT. But I have nested Structures. Whether it is possible to retrieve all the attributes in nested structures without using the SQLData ?
[ March 01, 2007: Message edited by: Srikanth Basavaraju ]

[Srikanth Basa]

Just thought of sharing that the following approach served my purpose.

I had a structure and within the structure they were simple attributes and some were Table types.

    
try {
Connection con = getConnection();
 
CallableStatement call = con.prepareCall("BEGIN mypackage.myprocedure(?,?,?, ?,?,?,?,?); END; ");
call.setString(1, "T"); 
....
....
// This is the structure
call.registerOutParameter(5, Types.STRUCT, sql_type_name);
....
....
call.execute();
 
STRUCT person = (STRUCT) call.getObject(5);
for (int i = 0; i < person.getAttributes().length; i++) {
if (!(person.getAttributes()[i] instanceof ARRAY)) {
System.out.print("S.no " + i + " - Value : " + person.getAttributes()[i] + "\n");
} else {
ARRAY subTypeArray = ((ARRAY) person.getAttributes()[i]);
System.out.println("-------------------------------------------------------------------");
System.out.println("S.no " + i + " Sub Structure name : " + subTypeArray.getSQLTypeName());
System.out.println("-------------------------------------------------------------------");
Datum[] datumArray = subTypeArray.getOracleArray();
 
for (int j = 0; j < datumArray.length; j++) {
STRUCT innerStruct = (STRUCT) datumArray[j];
for (int k = 0; k < innerStruct.getAttributes().length; k++) {
System.out.println("\tInner s.no " + k + " Subtype Attr Value : " + innerStruct.getAttributes()[k]);
}
}
System.out.println("-------------------------------------------------------------------");
}
}
} catch (Exception e) {
e.printStackTrace();
}

If you are looking for similar solution, hope you can do some research on above snippet to understand it

Cheers
Srikanth
[ March 01, 2007: Message edited by: Srikanth Basavaraju ]