Forum Discussion

nagitarami's avatar
nagitarami
Occasional Visitor
6 years ago

execute and edit a PL/SQL with extension file .SQL

good day dears:   I need to execute a plsql in testcomplete at run time and modify some parameters using the .sql archile It occurs to me to take several steps to create the procedures:   1....
AlexKaras's avatar
AlexKaras
Champion Level 3
6 years ago

Hi,

 

TestComplete does not provide any built-in means to execute SQL statements and uses ADO for this.

With the ADO, however, it is not possible to execute multi-line SQL statements.

Considering the above, if you really need to execute several dependent SQL statements, your only option is to use command-line tool provided by your SQL DBMS (sqlexec, etc.) and call this tool from TestComplete (either as Tested Application or via WshShell.Exec()).