Do CA API gateways perform JDBC query assertion supports calling a stored procedure?
Perform JDBC Query Assertion - CA API Gateway - 9.3 - CA Technologies Documentation
About half way down the page is the section on calling functions and stored procedures.
Hope this helps.
I am trying to get the count of an table using perform jdbc query assertion, it is expected to return approximately between 8k-10k records count.In this case, is it suggested to write a sql curry i,e select statement in the JDBC text box or call a stored procedure?
select count(*) from employee.
Either will work to achieve the results you are looking for. I would probably avoid a stored procedure for this simple query.