Hi Simon,

Below info helps you.

SQL Query tool functionality does not support CLOB and BLOB data types as mentioned by the error message. This is as designed.BLOB stands for binary large objects, which are used for storing binary data, such as an image. CLOB stands for character large objects, which are used to store string data too large to be stored in a VARCHAR column.

If there is a need to view the CLOB/BLOB, you can use oracle function TO_CHAR when retrieving values. 
As an alternative solution if you want to view the other columns you can run the query excluding CLOB/BLOB columns.

Also you can fetch above query without any issue In PLSQL or any other SQL tool.
 

Best Regards

-Kelum

Hi @Kelum Niranjana 

Thanks a lot for your help and the info. I managed to make a statement excluding the CLOB and BLOB columns and get the data I wanted! 

Kind regards,

Simon