Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

connect to oracle using cx_Oracle and pandas

bluef1shorclApr 9 2019 — edited May 22 2019

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

Comments

Post Details

Added on Apr 9 2019
3 comments
15,485 views