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