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

    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