i need to execute a stored procedure that returns a row. The stored procedure requires one string parameter, and returns a row. Then, i want to save the values of the row (5 columns) in independent variables. What is the best way to do this?
I'm doing it in a groovy script but it is giving me the following error:
No suitable driver found for jdbc:sqlserver://hostSql;database=DBName.
I'm using this code in the groovy script: