How do I get a kml which is stored in a blob file of oracle using ArcPy?

i try get data or kml files contains in a database oracle in a field of a table, using cursors options of arcpy.

import arcpy, os
from arcpy import env
source =r'C:\connectionFiles\file.sde\tableoracle'
cursor = arcpy.SearchCursor(source)

The conection works correctly, but the cursors do not work well for this type of information.


You might want to try the cx_Oracle package. From this Esri KB article:

import cx_Oracle

connection = cx_Oracle.connect('sde/sde@orcl')
cursor = connection.cursor()
querystring = "select * from table"

Above untested, as I don't have a Oracle instance to test against.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.