Oracle number columns become integer in sqlite

simonw / db-to-sqlite

CLI tool for exporting tables or queries from any SQL database to a SQLite file

Apache License 2.0

368 stars 28 forks source link

Oracle number columns become integer in sqlite #17

Open jhall39 opened 5 years ago

jhall39 commented 5 years ago

The database I'm working with has several columns set as number in Oracle. This utility creates the fields as integer in sqlite. It works if I remove the two fields that are number fields from my query. Otherwise it runs up until it encounters a noninteger number and then errors out with "Error binding parameter 64 - probably unsupported type" Additionally, I'm currently only including 6 fields in my select query, I don't know why it has 64 or more parameters.

simonw commented 5 years ago

I don't have access to Oracle for testing I'm afraid - leaving this open in the hope that an Oracle/SQLAlchemy expert can figure out what's going on here.