3 Replies Latest reply on May 22, 2019 5:55 AM by 3063555

    connect to oracle using cx_Oracle and pandas




      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.