We recently upgraded our Oracle database to 12c and since then our existing queries which were performing perfectly fine on 11g are not returning anything and it keeps running.
We have tested few queries and identified that some queries run normally but some just don’t.
As our database is managed by one of our IT partners, the same was informed to them and we were told that we need to upgrade the Oracle client on TOAD also to 12c, which we did but without any success.
We are on 3.6 version of TOAD.
We are not sure, if it is the ORACLE upgrade which is causing the issue or TOAD.
Any help would be much appreciated.
Thanking you, in anticipation of your response.