Passing parameter into stored procedure

Ignition
1

Hello,

I’m not sure of the correct syntax to pass two parameters into a stored procedure from a tag change event script.
To pass a single parameter I have -

            varPassParameter = 15
	varSecondPassParameter = 25		
	
	# call the stored procedure
	call = system.db.createSProcCall("storedProcedure")
	call.registerInParam(1,system.db.INTEGER, varPassParameter)
	system.db.execSProcCall(call)

What is the correct syntax to pass the second parameter?

Thank you.

2 
call = system.db.createSProcCall("storedProcedure")
call.registerInParam(1,system.db.INTEGER, varPassParameter)
call.registerInParam(2,system.db.INTEGER, varSecondPassParameter)
system.db.execSProcCall(call)
1 Like
3

Great, thank you for the response!