Script to Load file from Directory to Blob column
create or replace PROCEDURE load_file( pi_id IN INTEGER, pfname IN VARCHAR2) IS SRC_FILE bfile; dst_file BLOB:= EMPTY_BLOB(); lgh_file BINARY_INTEGER; BEGIN src_file := bfilename(‘dir’, pfname);…
Read More