Forum Discussion

Yan01's avatar
Yan01
Occasional Contributor
5 years ago
Solved

How to Execute SQL Stored Procedure with Parameters on TestComplete

Currently we need to run TestComplete to execute a stored procedure with parameters, when I run it in SQL MS, it looks like this: EXEC ar_sp_VarGroupUpdateXML @i_UserCode='mgb', @i_TerminalCode='',...
  • Yan01's avatar
    Yan01
    Occasional Contributor
    5 years ago

    Hi:

     I read through the article, but not sure this part: Call SProc.Parameters.AddParameter() SProc.Parameters.Items(0).name = "RETURN_VALUE" SProc.Parameters.Items(0).DataType = adInteger SProc.Parameters.Items(0).Direction = adParamReturnValue SProc.Parameters.Items(0).Value = Null

    For example: if I have a stored procedure A that has multiple parameter B, C, and D, then it has multiple lines of AddParameter function from 0 - 2? Another question, in the example script, there are multiple variables: DataType, Size, Direction, Value, what is the meaning of each one? If one of the paramater has value of XML format, how is it working? 

    • TanyaYatskovska's avatar
      TanyaYatskovska
      SmartBear Alumni (Retired)
      5 years ago

      Hi Yan01,

       

      A number of the AddParameter methods should be the same as a number of parameters you want to declare. Plus, make sure that you declared that out parameter (if a stored procedure returns something).

       

      As for other variables, you can find a detailed description in the Working with Stored Procedure Parameters article of the VCL documentation.