AnsweredAssumed Answered

cx_Oracle and python to move table data to numpy array

Question asked by HavardMoe on May 7, 2015
Latest reply on May 8, 2015 by HavardMoe

Hi everyone

 

I've got a question regarding moving some table data from an Oracle DB to a numpy arrays. I've looked into the possibility of using cx_Oracle to access my Oracle DB and read data (tested, works) and now I'd like to make numpy arrays out of the data to work with the table data locally. The thing is, I don't know the table/field structure of the source data before I begin, so I can't really hardcode the numpy.dptyp() field types up front. Do anyone know if there is a way of getting this from the Oracle DB using cx_Oracle so I can build the numpy.dptyp() for each table?

 

Alternatively, of course, is there a better way of achieving this that I haven't thought of? (Let's assume I don't have access to arcpy and Oracle connections there...)

Outcomes