trex12

geoprocessing join table with connect to oracle

Discussion created by trex12 on Dec 8, 2010
Latest reply on Jan 18, 2011 by hpbrantley
Hi,
is it possible to make geoprocessing join table with direct connect to oracle? I want to skip connect to sde..

something like this:
conn = cx_Oracle.connect('user','pass','server:1521/orcl')
curs = conn.cursor() 

stanice_denne = curs.execute("select * from KMIS_STANICE_DATA")
table_denne = curs.execute("select * from KOAK.GIS_DENNE_TEPLOTY")

gp.AddJoin_management(stanice_denne, "STATION_ID", table_denne, "STATION_ID", "KEEP_COMMON")

curs.close()
conn.close()

Outcomes