ArcSDESQLExecute support calling Functions

Question

Does the ArcSDESQLExecute class support calling Oracle functions?  If yes, does it further support the return of a ref_cursor?  I've tried

sql = "call BlahFunction()"
sdeReturn = conn.execute(sql)

Regards

JamesCrandall · Answer

Ah yes, one of those new 10.1 arcpy.da features I was referring to.  However, I need a v.10 solution.  😛

But your idea is a good one.

Regards

doh! bummer!

CharlesTilly · Answer

Ah yes, one of those new 10.1 arcpy.da features I was referring to.  However, I need a v.10 solution.  😛

But your idea is a good one.

Regards

JamesCrandall · Answer

Thanks for the replies.  I'm aware of the options you have suggested but I really need to invoke a function because one of the parameters needs to be a clob.  I could use the cx_Oracle module but then I get back a non-ESRI cursor that I then have to convert.  Ordinarily not a big deal but I have to do this a lot on a lot of data and in the interest of performance and maintenance.  I see v.10.1 has expanded the arcpy.da module with functionality that may do the trick.

Just to throw this out there, what about NumPyArrayToTable?  Wondering if you just add the cx_Oracle cursor (from the result of your function call) into an array then let the method do the work -- rather than doing all the gymnastics to get the field mapping done.  Not sure but I may have to look into this myself.

http://resources.arcgis.com/en/help/main/10.1/index.html#//018w00000016000000