4 Replies Latest reply: Jun 22, 2013 10:30 PM by user10685034 RSS

    SQL insert script for BLOBs

    ade_adekoya
      Hello

      I have managed to upload my word and pdf documents into the database using blob support in APEX and having these columns in MY_DOC table

      ,FILENAME VARCHAR2(400) NOT NULL
      ,BLOB_CONTENT BLOB
      ,MIME_TYPE VARCHAR2(48)

      Now I would like to migrate the data to another environment using a SQL insert script, how do I cater for the BLOB column in the insert script?

      Kind Regards

      Ade