How to obtain process object of just launched cmd
Hi there, I have one cmd instance launched (#1), and then I run one more instance (#2): var obj = Sys.OleObject("WScript.Shell")
obj.Run("C:\\Users\\admin\\run_sql.bat") After it I need...
When you try to run your PL/SQL script in test complete via an ADO connection and it fails, what is the failure you are seeing? Perhaps we can more easily work that out and you would then have a more robust way of generating your orders with parameters?
I found out that ADO connection can`t work with multiple PL/SQL blocks in one script. Like this:
variable a number; variable b number; def a = x; def a = y; begin .... end; / begin .... end; /
So I changed this to:
declare a number := x ; b number := y ; begin begin .... end; begin .... end; end;
And it helped! Now I can run my script via ADO, so I don`t need to run shell.
Thanks for all advices!
