I think only keep procedure itself should be better, for example:
Procedure invoke(... Procedure invokeHttp(...
I think the 'Procedure' should be remove, the execution command 'call' as well, in my test, exec also can execute the procedure:
exec invoke(...
"Call" is not a prefix, it execution command.
a procedure parameters can be supplied two different ways, when some of the parameters can be null/optional or have default values. When you are using
you need to provide input values for all parameters of the procedure, and parameter positioning must match with procedure definition. when using parameter named syntax like
you can omit the parameters where you want to use the default values, or pass in NULL. Also positioning of parameters is not significant.