CallProcedure

Call a relational database's stored procedure and obtain the result .

Function CallProcedure( proc_name, input_params, output_params )

string proc_name - name of the procedure to call

array input_params - input parameters for the procedure

array output_params - output parameters

Let's say we have created a procedure in Transact-SQL:

CREATE PROCEDURE [dbo].[p_MyProc] @par1 varchar(255), @par2 varchar(255), @par3 varchar(255), @out1 int OUTPUT, @out2 int OUTPUT AS

BEGIN

@out1 = 1

@out2 = 2

return 3

END

Then we can call it as follows:

Dim output, retval

retval = this.DSOut.CallProcedure( "p_MyProc", Array( "val1", "val2", "val3" ), output )

Values after the call:

IsArray( output ) = true

output(0) = 1

retval = 3

integer - procedure's return value