Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to get the data from PARAMS column using JDBC java

Abhishek Sahu-OracleNov 21 2022 — edited Nov 21 2022

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.

Screenshot 2022-11-21 115928.pngThe 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.

This post has been answered by Abhishek Sahu-Oracle on Dec 9 2022
Jump to Answer

Comments

Post Details

Added on Nov 21 2022
2 comments
363 views