0

I am using Oracle SQL Developer Tool, I have a table which has blob data type and we are storing XML in the blob object. I am not able to see the data stored in blob object either in text format or image format using oracle sql developer 4.0.3.16 version.

I tried to use the queries:

SET MARKUP HTML ON SPOOL ON; 
SPOOL report.html;
 select substr(clob_columnName , 1, 32767) from tableName...

But the output of the query is :

ORA-00932: inconsistent datatypes: expected CHAR got BLOB.

Please help me to view the blob data somehow

Improve this question
5
  • check here: stackoverflow.com/questions/28449798/… Commented Jan 24, 2018 at 20:23
  • Hi Jack, the solution mentioned in the above link i have already tried and its not working for me. when i try with SET MARKUP HTML ON SPOOL ON; SPOOL report.html; select substr(clob_columnName , 1, 32767) from tableName... but the output of the query is ORA-00932: inconsistent datatypes: expected CHAR got BLOB. thank you very much for answering my question Commented Jan 24, 2018 at 20:28
  • 1
    XML is text, isn't it? Why do you store it in Binary Large Object (BLOB) data type column, instead of Character Large Object (CLOB)? Commented Jan 24, 2018 at 20:34
  • You can't use substr() on a BLOB column. Commented Jan 24, 2018 at 22:00
  • you are correct, ideally it should be clob, but this table came with base product. So i cannot modify data type. can you please help me how to overcome this problem. Commented Jan 25, 2018 at 15:36
Related questions
148
How do I get textual contents from BLOB in Oracle SQL
12
Oracle database: How to read a BLOB?
1
Oracle BLOB column reading
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.