2 Replies Latest reply on Nov 22, 2004 6:20 PM by 419660

    Can Interconnect deal with binary files?

    Toon Koppelaars
      I am trying to use Interconnect to pick up a jpeg file using the FTP-adapter and to insert it into the database as a BLOB-value using the database adapter.

      I have the following issues:
      1) Interconnect encodes the binary file.
      2) The encoded file is limited to 32K.
      3) Interconnect inserts into the database as a LONG value.
      Once encoded as LONG in database, there is no easy way how to un-encode the LONG value and transfer it into a BLOB value (using PL/SQL).
      Preferably I would like Interconnect to directly insert the jpeg file as a BLOB into the database

      Any ideas?