Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Oracle number columns become integer in sqlite #17

Open
jhall39 opened this issue Jul 11, 2019 · 1 comment
Open

Oracle number columns become integer in sqlite #17

jhall39 opened this issue Jul 11, 2019 · 1 comment
Labels
bug Something isn't working help wanted Extra attention is needed

Comments

@jhall39
Copy link

jhall39 commented Jul 11, 2019

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 simonw added bug Something isn't working help wanted Extra attention is needed labels Jul 14, 2019
@simonw
Copy link
Owner

simonw commented Jul 14, 2019

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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working help wanted Extra attention is needed
Projects
None yet
Development

No branches or pull requests

2 participants