connect to oracle using cx_Oracle and pandas

bluef1shorcl

Hi,

I am trying to fetch data from oracle database using cx_Oracle and pandas.

Windows 10 , oracle client installed

how do I provide arraysize parameter for faster fetch ?  I have tried passing it as dict to params in pandas.read_sql( sql, connection, params={'arraysize':500}) but this throws error.

I found examples online suggesting to initiate oracle connection using SQLAlchemy and then pass this into pandas.read_sql. but this is one additional package to import.

Regards,

aneesh

bluef1shorcl

I found something online here -

https://github.com/oracle/python-cx_Oracle/issues/132

Gaz in Oz

Thanks for posting the link to a solution.

I have included it here so as the "answer" is not lost:

import cx_Oracleimport pandas as pdclass Connection(cx_Oracle.Connection):  def cursor(self):  cursor = super(Connection, self).cursor()  cursor.arraysize = 5000  return cursorconn = Connection("dellera", "dellera", "ora12c")# prints 5000print(conn.cursor().arraysize)df = pd.read_sql_query("select object_id from dba_objects", conn)

User_BGHTM

help for below connection = cx_Oracle.connect('apps',pwd,dsn_tns) cx_Oracle.DatabaseError: DPI-1050: Oracle Client library is at version 0.0 but version 11.2 or higher is needed