db-to-sqlite icon indicating copy to clipboard operation
db-to-sqlite copied to clipboard

Published 20 hours ago • verified publisher icon simonw

Oracle number columns become integer in sqlite

Open jhall39 opened this issue 6 years ago • 1 comments
trafficstars

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.

jhall39 avatar Jul 11 '19 19:07 jhall39

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.

simonw avatar Jul 14 '19 06:07 simonw