Forum Discussion

Rammherz's avatar
Rammherz
Occasional Contributor
7 years ago
Solved

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...
  • cunderw's avatar
    cunderw
    7 years ago

    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? 

  • Rammherz's avatar
    Rammherz
    7 years ago

    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!

     

Rammherz's avatar
Rammherz
Occasional Contributor

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!