DB Toolbox: Calling Store Procedure

Hi,

I am using the Database toolbox to execute the store procedure.

tSQL = ['{call LiveCAT.dbo.[nameOfSP]('input1','input2')}'];

execute( connDB, tSQL)

info = fetch(connDB, ' SELECT * FROM #Results')

or

curs = exec( conn, tSQL);

dbList= fetch( curs);

I didn't get any return result. I think it didn't work because there're interim SQL statement in between before final SELECT query. Please provide suggestion.

The SP looks like this

ALTER PROCEDURE [dbo].[nameOfSP] (@peril varchar(255), @name varchar(255))

AS

BEGIN

create table #Results

(Exposure_BaseId bigint null, Company varchar(400))

INSERT INTO #Results(Exposure_BaseId, Company )

Exec(@myQuery)

Select distinct Exposure_BaseId,Company ,

from #Results

END

Answer 1

[Pete sherer]

I tried to use command 'runstoredprocedure' but it seems that function doesn't exist anymore.