Forum OpenACS Q&A: Response to Inserting a image file in ORACLE

Collapse
5: Response to Inserting a image file in ORACLE (response to 1)
Posted by Cynthia Kiser on 04/26/02 08:19 AM
I think the error message you are getting is due to lack of ' ' around my Your error log shows: 
  insert into pic_table 
    (name, pic) 
  values 
    (my, empty_blob()) 
  returning pic into :1
Try '$name' so that that ends up as ('my', empty_blob())