How to insert file blob into sql database

• • Reply

  13 years ago

  by Cindy7

  Cindy Ng

  , United States

  Joined 13 years ago

  I would like to insert all different type of file into database and retrieve back. The user will upload file to database and dowload back for viewing if need.

  The data type is blob, here is my table:
  SQL> create table ICE (
  2 file_id raw(16) default sys_guid() primary key,
  3 file_content blob)
  4 /
  
  
  
  

  The problem is when I upload the file, the error message display and the file doesn't save in database.
  
  

  <cffile action="upload"
  filefield="form.FileName"
  destination="C:\temp\"
  nameconflict="makeunique"
  accept="application/octet-stream, application/vnd.ms-excel">
  
  <cffile
  action = "readbinary"
  file = "C:\temp\#cffile.serverFile#"
  variable="file_blob">
  
  <cfquery name="add" datasource="TEST">
  insert into TestFile (file_content)
  values (
  <cfqueryparam
  value="#file_blob#"
  cfsqltype="cf_sql_blob">
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  

  How can I insert file into database using SQL Plus?

  Any help very appreciated.

   

  
   
  

   

  Report abuse