Forum Discussion

dsolis2's avatar
dsolis2
Occasional Contributor
14 years ago

Database Options

I have a large query I use to access an Oracle database to do some clean up operations after my script is done running. I have a few question on the best route to do this:



 1. Open an ADO connection to a Oracle database and run the query. This option seems easy enough, but the query is over 30 lines long. Can I use the ADO connection and excute the query from a file? If so, how would that work?



2. The other option is to use SQLPLUS from TC as I was reading the article about Oracle operations although it doesn't tell me much about how SQLPLUS and TC interact to execute these operations. It seems I need Automated Build Studio???

http://www.automatedqa.com/support/viewarticle.aspx?aid=1411



3. Lastly, the easiest by far is to write a batch file that makes a connection via the command line to the database and calls my query. This is basically what I was doing in WinRunner. However, How do I run an executable file, like a .bat file, from TC?

1 Reply