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()
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.
It doesn't look to be complete script. Are you seeing the gp services log messages when you are calling append ?
I do have experience in uploading data that will be used in gp service. Following is a blog that helped me in understanding.
Basically you need to zip your shapefile and upload it then do whatever you want to do with it.