How to get the data from PARAMS column using JDBC java

User_EOYHX

I have a table named- Reports . It has a column name - PARAMS. After executing DESCRIBE REPORTS ,It's datatype shows as OPERA_SRW_PARAMLIST which is a user defined datatype.

I have a result set which has data from query- "SELECT PARAMS FROM REPORTS";

I tried to get that column data in my java code but i am getting NULL for that column.

The data present in the PARAMS column looks like this-

DUMMY_DATA_TO_TEST([DUMMY], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2],  
[DUMMY], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], 
[DUMMY], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], 
[DUMMY], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], 
[DUMMY], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], 
[DUMMY], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], 
[DUMMY], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], 
[DUMMY], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], 
[DUMMY], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], 
[DUMMY], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], 
[DUMMY], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], 
[DUMMY], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], 
[DUMMY], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], 
[DUMMY], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], 
[DUMMY], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], [DUMMY2], )

I tried below code to retrieve data as a string but not successful.

while (resultSet.next()) {
    
    System.out.println(resultSet.getString("PARAMS"));
}

Please suggest me any good way to retrieve that column data in my java code. Thanks in advance.

User_83CIE

@User_EOYHX , is params a blob data type?

If that's the case , you can unmarshall it and convert it to object.