Mass creation of Attachments from an oracle "BLOB" table

Discussion created by txdot2012@gmail.com on Feb 13, 2013
Latest reply on Sep 13, 2013 by mvolz47

Please forgive me with my newbie question. I am still learning my way around ArcGIS 10.1 and python

Is this possible to write a python script to perform batch loading attachments from a blob column of an oracle table ? In this case, I have a featureclass with MATCHID field (say PIC_ID). I also have a "detail" oracle table that has coresponding PIC_ID column and the image is stored in a blob column.

I went through the add attachments example of ArcGIS 10.1 using matching table to generate attachment by loading image from file folders using "arcpy":


The above example loads images from an o/s folder.  Is this feasible to use a similar python script with arcpy & cx_oracle to add attachment using data from a blob column in an oracle table ? or is there other tool in Arcgis to perform this task in batch ?

Thank you in advance for any pointers.