AnsweredAssumed Answered

GP Service to spatial data from shape file to oracle spatial

Question asked by praveen.narayandas on Feb 3, 2015
Latest reply on Feb 3, 2015 by mahtab.gis

Hi all,


i am able to load the shape files into ArcSDE oracle spatial using below script


for shpFile,oraTable in zip(arrRawFC,arrOracleFC):

        for inFC in arcpy.ListFeatureClasses(shpFile+'*'):

arcpy.AddMessage( 'Appending'+shpFile+ 'to'+'Database Connections/MySDE_dev.sde//'+oraTable)


arcpy.Append_management(inFC, 'Database Connections/MySDE_dev.sde//'+ oraTable , 'NO_TEST', '', '')

            except Exception as e:

                # If an error occurred, print line number and error message       

                tb = sys.exc_info()[2]

#arcpy.AddMessage("Line {0}".format(tb.tb_lineno))



i have published script as GP service and when i am executing it it is tool is executing but no results in oracle table.


can any one is having idea how to load shape files on to oracle spatial on web application.


thanks for help.


best regards,