• 110
    0

    Copying Data from a File into a CLOB in Oracle  The following copy_file_data_to_clob() procedure shows how to read text from a file andstore it in a CLOB:CREATE PROCEDURE copy_file_data_to_clob(p_clob_id INTEGER,p_directory VARCHAR2,p_file_name VARCHAR2) ASv_file UTL_FILE.FILE_TYPE;v_chars_read INTEGER;v_dest_clob CLOB;v_amount INTEGER := 32767;v_char_buffer VARCHAR2(32767);BEGIN— insert an empty CLOBINSERT INTO clob_content(id, clob_column) VALUES (p_clob_id, EMPTY_CLOB());— get the LOB locator of ...