Forum Stats

  • 3,770,583 Users
  • 2,253,137 Discussions
  • 7,875,499 Comments

Discussions

connect to oracle using cx_Oracle and pandas

bluef1shorcl
bluef1shorcl Member Posts: 4
edited May 22, 2019 1:55AM in Python

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

Tagged:
Gaz in OzChristopher Jones-Oracle

Answers