I have a sql file (query.sql) that is generated by a script and needs to run and have the results exported to a flat file daily. The issue is that query.sql changes every day so I can’t use the Export Query option in the Export Dataset module. I can run the query.sql in the main window by using:
However, I want to be able to set it up in automation designer. Ideally I would want to combine the two and do something like the image below where I call a query into the export dataset then export the results, but that causes an invalid SQL statement error. Is this possible or is there another way to approach it?
Thank you for any suggestions. I am running Toad for Oracle 126.96.36.199 64 bit.