Execute stored procedure from TestStand

[Kezar]

I am having difficulty executing a stored procedure from the TestStand Database step types.  I am using the "Data Operation" step type to set the input parameter, but I still get the following error;

Procedure or function 'sproc_prior step' expects parameter '@serial_number', which was not supplied.

I've attached the sequence file for review.

Any help would be appreciated.

[herosphro]

We were able to fix this sequence by making the following changes:

1.) In the Open SQL Statement change the Command Type to Stored Procedure instead of Default.

2.) On the Get Results step change the Operation to Get - Retrieve Values from Record instead of Close since the Close SQL Statement takes care of that for you.

3.) Also change the Record To Operate On to Current - Use Current Record.

After making these changes the sequence should work.  Also note, that it would be preferable to change the stored procedure name to us all underscores and not spaces since this is more standard for use with databases.