A PL/SQL block to read an operating system file called BLOB.JPG that contains 1 row of binary data. : UTL_FILE « System Packages « Oracle PL/SQL Tutorial

SQL>
SQL>
SQL> create table myTable(
  2     c1 number primary key,
  3     c2 blob
  4  );

Table created.

SQL>
SQL>
SQL> DECLARE
  2    v_raw           RAW(32767);
  3    v_file_id       UTL_FILE.FILE_TYPE;
  4  BEGIN
  5      v_file_id:=
  6      UTL_FILE.FOPEN('c:\','blob.jpg','r',32767);
  7      UTL_FILE.GET_RAW (v_file_id,v_raw);
  8      INSERT INTO myTable VALUES (1,v_raw);
  9      UTL_FILE.FCLOSE( v_file_id);
 10  END;
 11  /



SQL>
SQL>
SQL> drop table myTable;

Table dropped.

31.38.UTL_FILE
	31.38.1.	File open and close with UTL_FILE package
	31.38.2.	File open flags
	31.38.3.	Save table records to a file
	31.38.4.	Use UTL_FILE package to create a file
	31.38.5.	Open a file with mode passed in
	31.38.6.	utl_file.invalid_&&firstparm
	31.38.7.	UTL_File related exception
	31.38.8.	UTL_FILE.IS_OPEN
	31.38.9.	A PL/SQL block to read an operating system file called BLOB.JPG that contains 1 row of binary data.