• [x ] I have checked that this issue has not already been reported.

  • [ x] I have confirmed this bug exists on the latest version of pandas.

  • [ ] (optional) I have confirmed this bug exists on the master branch of pandas.

Note: Please read this guide detailing how to provide the necessary information for us to reproduce your bug.

Code Sample, a copy-pastable example

                        df.to_sql(name=table_name,
                                  con=engine,
                                  if_exists='append',
                                  index=False,
                                  chunksize=1000,
                                  dtype=dtype
                                  )

Problem description

If I run this code and the column names are greater than 30 I get: (cx_Oracle.DatabaseError) ORA-01008: not all variables bound

It creates the table correctly, but the insert fails. In sqlalchemy, my engine is defined as: engine = create_engine(url, echo=False, max_identifier_length=128)

If I shorten the long column names, it works perfectly.

Expected Output

Output of pd.show_versions()

[paste the output of ``pd.show_versions()`` here leaving a blank line after the details tag] '1.0.5'

Comment From: mroeschke

Thanks for the issue but unfortunately this isn't reproducible and we dont have the ability to test with cx_Oracle in our CI so closing