Oracle table to file geodatabase

Discussion created by Pi-Hellz on Feb 23, 2012
Latest reply on Feb 24, 2012 by foresterdave

I'm a beginner in Python and trying to build a script to perform and extraction from a Oracle database to a file geodatabase with a SQL query. I've been able to etablish the connection to Oracle, select the data with the query, create a new table but I have not been able to successfully output the data to the file Geodatabase.

Here the error from the geoprocessing result.

Voici mon code :

#! /usr/bin/env python

import cx_Oracle
#import csv
import arcpy
from arcpy import env

# Define workspace
env.workspace = "C:\Temp\Extraction_Toad\Scratch_Toad.gdb"

# Add connections setting
dsn = cx_Oracle.makedsn("XXXX","XXX","X")
orcl = cx_Oracle.connect('XXXXX','XXXXX',dsn)
cursor = orcl.cursor()

# Get the variables
arg1 = arcpy.GetParameterAsText(0)
out_path = arcpy.GetParameterAsText(1)
out_name = arcpy.GetParameterAsText(2)
template = "C:\Temp\Extraction_Toad\Template_vue.dbf"
out_workspace = "C:\Temp\Extraction_Toad\Scratch_Toad.gdb"

# Process the query
sql = arg1

rows = cursor.fetchall()

# Create a new table

# Loading data from the cursor to file g
for row in rows:

Thanks for you help