Service Virtualization

  • Private Community

  • 1.  Can we run store procedure in dev test ?

    Posted May 10, 2017 05:46 AM

    I want to run the below store procedure as such. Is that possible in dev test.

     

    {call RETEK.GET_SKU_CAP_FEED_VIEW.GET_SKU_CAP_FEED (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}

     

    The '?' is meant for Input Value which of type Array / Varchar.



  • 2.  Re: Can we run store procedure in dev test ?
    Best Answer

    Posted May 10, 2017 10:35 AM

    According to the documentation for the SQL Database Execution step, stored procedure calls are supported.

     

    https://docops.ca.com/devtest-solutions/10-1/en/reference/test-step-descriptions/other-transaction-steps/sql-database-execution-jdbc



  • 3.  Re: Can we run store procedure in dev test ?

    Posted May 10, 2017 10:53 AM

    It should work as long as you passed values or properties for all parameters in store procedure.  Please make a note you can not call sql query as inside parameters.  however we can store them in excel data sheet and pass as properties as parameters in SP. 

     

    Thanks, 

    Rajesh k Singh