Oracle BLOB extract/view - TechRepublic
General discussion
March 28, 2001 at 08:54 AM
mwright

Oracle BLOB extract/view

by mwright . Updated 25 years, 3 months ago

I am having trouble finding the best way to display BLOB data from an Oracle table via PL/SQL.

I had limited success getting data out via
DBMS_LOB.SUBSTR() — but it is just numbers representing the binary code. The particular BLOB data thatI wish to extract and view is RTF (formatted) text. Additionally, Is there a way (function/package) to convert it to plain ASCII text?

This discussion is locked

All Comments