Database V2 get operation doesn't return stored procedure output when it has a temp table


Issue Description: 
Database V2 get operation returns 200, and "Process executed Successfully" instead of showing actual stored procedure output when a stored procedure has a temp table. However, it returns correct output response when stored procedure doesn't have a temp table.

Example:
For instance, let's say you want to execute below stored procedure using Database V2 connector, instead of returning the output as below it returns the output as 200, and "Process executed Successfully" .

'col_A_val','col_B_val'
CREATE PROCEDURE dbo.sp_with_temp(
@inp_param nvarchar(100) = NULL)
AS
BEGIN
DECLARE @temp as Table ( col_A nvarchar(100) NOT NULL, col_B nvarchar(100) NULL)
INSERT INTO @temp (col_A, col_B) SELECT 'col_A_val','col_B_val'
SELECT col_A, col_B FROM @temp
END


To get the correct output using database V2 connector, please make sure to add "SET NOCOUNT ON;" in a stored procedure, so that the final stored procedure be like below. And now it will return the expected response.

CREATE PROCEDURE dbo.sp_with_temp(
@inp_param nvarchar(100) = NULL)
AS
BEGIN
SET NOCOUNT ON;
DECLARE @temp as Table ( col_A nvarchar(100) NOT NULL, col_B nvarchar(100) NULL)
INSERT INTO @temp (col_A, col_B) SELECT 'col_A_val','col_B_val'
SELECT col_A, col_B FROM @temp
END


Analysis:
We (Boomi) use execute() method and that returns "false" when procedure is using temp table. It returns false considering the result has an update count. Setting NOCOUNT ON explicitly, execute() method returns "true" and we see the expected output returned by the database V2 connector.