How do I convert blob to xml string?
Hello everyone,
I need a help to read a xml string larger than 4000 in stored procedure.
CREATE OR REPLACE PROCEDURE PROD.InsertFDataBlob(V_MYBLOB BLOB) AS
BEGIN
........
passing SYS.XMLTYPE(V_MYBLOB)
.......
I could not find a simple way to convert my blob value which is V_MYBLOB to varchar. My database versions are 10g and 11g.
Thank you.