pandas df.to_sql with oracle returns ORA-01008: not all variables bound

Question

I am reading a csv from and api, and I am able to stream it into a pandas dataframe.

df = pd.read_csv(iterable_to_stream(reply.iter_content()),
                                         skiprows=7,
                                         dtype=str,
                                         na_filter=False)

I checked the dataframe and it all looks good. Then wanted to put that data into an Oracle table. Its only got 65 rows of VARCHAR2(100) so I did this

df.to_sql(name='KR_PERSON_DETAILS_CSV_PD',
          con=db.engine,
          index=False,
          if_exists='append',
          dtype={line: types.VARCHAR(100) for line in df.columns}
)

When I do this I get the following message: sqlalchemy.exc.DatabaseError: (cx_Oracle.DatabaseError) ORA-01008: not all variables bound

How can this be? The table is created when I run it and I double checked all the columns.

what is your connection string? change connetion string might solve your question. similar question is here. — S.Hashiba
– S.Hashiba, Commented Sep 17, 2020 at 21:29
The connection string is a sqlalchemy engine. url =f"oracle+cx_oracle://user:password@{dsn}" self.engine = create_engine(url, echo=False, max_identifier_length=128). The sql it produces looks good. — CrabbyPete
– CrabbyPete, Commented Sep 18, 2020 at 13:10

CrabbyPete · Accepted Answer · 2020-10-02 13:40:23Z

1

I discovered the problem. Some of the column names were larger than 30 characters. I shorted those column names greater than 30 characters and it works

answered Oct 2, 2020 at 13:40

CrabbyPete

5349 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

pandas df.to_sql with oracle returns ORA-01008: not all variables bound

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related