Hello All
Am using the Oracle MDA Utility VBO present on DX to execute my Oracle queries and save the results directly to a CSV. The problem is it works fine for the first query run but in case my second query run happens to be on a different connection string, the execution fails and I get the error - 'ORA-00942: table or view does not exist.
If I then go ahead and refresh my process and re-attempt the failed query run, it works just fine. I have a hunch that the previous connection doesn't get closed and the new connection isnt successfully established with the schema when I run the utility in a loop, even though closing any existing connections is a part of set connection action.
Would really appreciate your guidance with respect to the same.
Best
