Load table to Oracle through pandas io SQL

I had the same issue when using cx_Oracle connection (I was able to use .read_sql function, but not the .to_sql one)

Use SQLalchemy connection instead:

import sqlalchemy as sa
oracle_db = sa.create_engine('oracle://username:password@database')
connection = oracle_db.connect()
dataframe.to_sql('table_name', connection, schema='schema_name', if_exists='append', index=False)