Hi,
I tried the SQL statement:
select *
from business_lead
And then receive the following error message:
Does someone know what this message means and why it occurs?
Kind regards,
Simon
Best answer by Kelum Pradeep Kumara
View original
This topic has been closed for comments
Userlevel 7
+18
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
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
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.