Load the data into table myTable. You may use any valid number for column c1's data. : UTL_FILE « System Packages « Oracle PL / SQL






Load the data into table myTable. You may use any valid number for column c1's 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.Writing "Hello World!" to a File
2.Use UTL_FILE.PUT_LINE to write a line of text to a file
3.Use utl_file.fopen to open a file
4.Use UTL_FILE.FCLOSE to close a file
5.Use UTL_FILE to read from a file and insert into the lecturer table.
6.Use UTL_FILE to print a transacript to a file.
7.Catch different UTL_FILE related errors
8.Save data in a cursor to a file