58.1 BLOB_TO_CLOB Function
This function converts a BLOB to a temporary CLOB.
Syntax
APEX_UTIL.BLOB_TO_CLOB (
p_blob IN BLOB,
p_charset IN VARCHAR2 DEFAULT NULL,
--
p_in_memory IN VARCHAR2 DEFAULT 'Y',
p_free_immediately IN VARCHAR2 DEFAULT 'Y' )
RETURN CLOB;
Parameters
Table 58-1 BLOB_TO_CLOB Parameters
Parameter | Description |
---|---|
p_blob |
BLOB to be converted to a CLOB. |
p_charset |
Character set of the BLOB to be converted. If omitted, the database character set is assumed and no character set conversion happens. |
p_in_memory |
If Y is specified, create the temporary LOB in memory.
|
p_free_immediately |
If Y is specified, clean up the temporary LOB after the top-level call.
|
Returns
Temporary CLOB containing the BLOB contents.
Example
The following example grabs website contents as BLOB and converts it to a CLOB.
DECLARE
l_clob clob;
l_blob blob;
BEGIN
l_blob := apex_web_service.make_rest_request_b(
p_url => 'https://www.example.com/',
p_http_method => 'GET' );
l_clob := apex_util.blob_to_clob(
p_blob => l_blob );
sys.dbms_output.put_line( 'The CLOB has ' || sys.dbms_lob.getlength( l_clob ) || ' bytes.' );
sys.dbms_output.put_line( '--------------------------------' );
sys.dbms_output.put_line( sys.dbms_lob.substr( l_clob, 80, 1 ) );
END;
Parent topic: APEX_UTIL