BLOB to CLOB using Base64 results in REP-271504897: Unable to retrieve a string from the Report Bui
Hello,
Our PO Printing report requires that the Approver's signature should appear. I was trying to convert the BLOB image to CLOB by using this function inside the query in Reports Builder:
CREATE FUNCTION xx_getbase64( p_source BLOB )
RETURN CLOB
IS
v_result CLOB;
BEGIN
DBMS_LOB.createtemporary(lob_loc => v_result, CACHE => FALSE, dur => 0);
Wf_Mail_Util.EncodeBLOB ( p_source, v_result);
RETURN ( v_result );
END xx_getbase64;
When I tried to run the concurrent program to produce the XML data, I keep getting this error message:
REP-271504897: Unable to retrieve a string from the Report Builder
But if I removed the call to this function, the report produces the XML data.
Our PO Printing report requires that the Approver's signature should appear. I was trying to convert the BLOB image to CLOB by using this function inside the query in Reports Builder:
CREATE FUNCTION xx_getbase64( p_source BLOB )
RETURN CLOB
IS
v_result CLOB;
BEGIN
DBMS_LOB.createtemporary(lob_loc => v_result, CACHE => FALSE, dur => 0);
Wf_Mail_Util.EncodeBLOB ( p_source, v_result);
RETURN ( v_result );
END xx_getbase64;
When I tried to run the concurrent program to produce the XML data, I keep getting this error message:
REP-271504897: Unable to retrieve a string from the Report Builder
But if I removed the call to this function, the report produces the XML data.
0