We have a strange toad file load issue happening.
Toad version noted in: 3.1 and 4.3
Database Backend: Oracle
We can make a database connection without any issue.
We can build new queries and run them without any issues.
But starting yesterday afternoon, if we load a query or build a new query, save then re-load it; we see the following errors (types) on loading a saved :
Input string was not in a correct format. Couldn't store (table name) in ColumnOrder Column. Expected type is Int32. Opening query in editor. Please connect to a database and send the query to the Query Builder to be visualized.
Or we see:
Can not find column6. Opening query in editor. Please connect to a database and send the query to the Query Builder to be visualized.
I've worked with our DB admin, there doesn't seem to be an issue on the DB side. For example, if I copy the raw SQL into a new Query Builder window and execute it, it runs correctly. We have tried a clean install of Toad 4.3 for a user and encountered the same issue after clean install.
Has anyone experienced this or know what might be happening?