BLOB2CLOBBASE64 Function
This function is used to convert Blob to base64Clob.
Syntax
APEX_WEB_SERVICE.BLOB2CLOBBASE64 ( p_blob IN BLOB) RETURN CLOB;
Example
declare
l_clob CLOB;
l_blob BLOB;
begin
SELECT BLOB_CONTENT
INTO l_BLOB
FROM APEX_APPLICATION_FILES
WHERE name = :P1_FILE_NAME;
l_CLOB := apex_web_service.blob2clobbase64(l_BLOB);
end;
No comments:
Post a Comment
Please do not add any spam links or abusive comments.