Table Blob to Oracle Directory
How to save table images to oracle directory? Files from table to Oracle directory
DECLARE l_file UTL_FILE.file_type; l_buffer RAW (32767); l_amount BINARY_INTEGER := 32767; l_position INTEGER := 1; l_blob_length INTEGER; BEGIN FOR l_cnt IN (SELECT filename, product_image FROM demo_product_info) LOOP l_file := …