> I need to extract a substring from a BLOB using a PL/SQL program. To
> extract the substring from the BLOB, i'm using the dmbs_lob.substr()
> function. Problem is that it gives me a string in hexadecimal
> characters back, while i need the string to be in readable ascii
> format.
Apply UTL_RAW.CAST_TO_VARCHAR2() to the output of
DBMS_LOB.SUBSTR() and there you have it.
--
Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.
Received on Thu Apr 03 2003 - 09:22:09 CST
