A PL/SQL block to read an operating system file called BLOB.JPG that contains 1 row of binary data. : blob « Data Type « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Data Type
  3. blob

A PL/SQL block to read an operating system file called BLOB.JPG that contains 1 row of binary data.

 


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.








Related examples in the same category

1.Read data in for sql statement
2.Blob type column
3.Initialize blob type data
4.Read blob type data, DBMS_LOB.READ