declare
    v_file_blob    blob;
    v_file_clob    clob;
    v_file_size    integer := dbms_lob.lobmaxsize;
    v_dest_offset  integer := 1;
    v_src_offset   integer := 1;
    v_blob_csid    number := dbms_lob.default_csid;
    v_lang_context number := dbms_lob.default_lang_ctx;
    v_warning      integer;
begin
    dbms_lob.createtemporary(v_file_clob, true);
    
    select blob_content into v_file_blob
    from apex_application_files
    where name = :MY_FILE_BROWSE_ITEM;
    
    dbms_lob.converttoclob(v_file_clob,
                           v_file_blob,
                           v_file_size,
                           v_dest_offset,
                           v_src_offset,
                           v_blob_csid,
                           v_lang_context,
                           v_warning);

    :MY_TEXT_AREA := v_file_clob;

    dbms_lob.freetemporary(v_file_clob);

    delete from apex_application_files
    where name = :MY_FILE_BROWSE_ITEM;
end;