I have updated my Toad for Oracle from Version 9.7.1 to 18.104.22.168 and now the batch file is not working.
I created a batch file to run a .sql file using older version of Toad(Version 9.7.1). We updated the toad to latest version (Version 22.214.171.124) but now the batch file is not able to execute the .sql file. I changed the URL so that it refer to new toad.exe file, batch file is able to open the sql file but unable to run it.
Below is the code
echo start cls
cd C:\Program Files (x86)\Quest Software\Toad for Oracle 13.1\ %systemroot%\Syswow64\cmd.exe /K Toad.exe -c USER_ID/Password@Database -f "C:\working\Automation\Batch_Files\TPR_Code_SCDM_Auto.sql" /exec
PROMPT TABLES UPDATED
GOTO:EOF EXIT /B