Run SQL file

[paulohg6]

My problem is:

I have a very large sql to run, and my idea was to externalize this sql to an external file and just run it through testcomplete is there any way to accomplish this? my database is oracle my application is descktop

[DWalsh]

please review similar posting in the community https://community.smartbear.com/t5/TestComplete-Functional-Web/How-to-run-a-sql-file-querys/td-p/880...

I would also make sure that you can connect to the database from the machine where TestComplete is installed say from an odbc datasource configuration setup

[paulohg6]

I read that but i don't understand how to do . 

I can connect to the database, but to run large sql is a lot of work to do with the code (because it needs the string to be in a specific format to be recognized with delphiscrit for the string to be accepted) so the idea of ​​externalizing the file

[DWalsh · Accepted solution]

So the SQL you want to execute, can you run it say from a batch file outside of TestComplete?. If so you one way is to add your batch file as a TestedApps object and run it:

TestedApps.yourBatch.Run()