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: get_table_description raises error after ALTER TABLE ... DROP COLUMN statement #22

Open
erny opened this issue Nov 7, 2018 · 2 comments

Comments

@erny
Copy link
Member

erny commented Nov 7, 2018

With cx_Oracle 6.4.1 and Django 1.4.18 django's get_table_description raises:

DatabaseError: ORA-00932 inconsistent datatypes: expected ... got ...

when executing this function on the same after the table has been altered.

@erny
Copy link
Member Author

erny commented Nov 7, 2018

It seems that the table description is cached elsewhere. I only get this error using the current transaction scheme, but not when I use the native database cursor directly. Strange that executing the get_table_description for the second time, the error disappears.

I've tried to debug this error but didn't found the exact reason.

@erny
Copy link
Member Author

erny commented Nov 7, 2018

This error can be avoided not re-reading the table description each time. It should be enough getting the table description only one time for each model.

erny added a commit to tangrambpm/django-transmeta that referenced this issue Nov 7, 2018
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant