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)
Post a Comment for "Loading Dataframe From Pandas To Sql For Oracle Yields And Error - Ora-00911: Invalid Character"