Loading DataFrame From Pandas To SQL For ORACLE Yields And ERROR - ORA-00911: Invalid Character

I am attempting to load a dataframe from Pandas to Oracle. I can read_sql just fine, but df.to_sql does not work. Here is the error: Error on sql SELECT name FROM sqlite_master WH

Solution 1:

You have to provide the sqlalchemy engine to to_sql and not the raw connection. Supplying the DBAPI connection is only supported for sqlite3 databases (see docstring).

Further, a pandas version of 0.14 or larger is needed for this functionality (before, only sqlite and mysql were supported)