Unnamed call after named call

It is not recommended to use the position notation after the named notation when calling a procedure.

Parameters can be passed by position in a comma-delimited list, or by name, but it is a bad idea to mix the two methods even when it is possible. If a parameter has a default value assigned to it, it can be left out of the parameter list, and it is difficult to check whether the values you supply are for the parameters you intend.

Available in

SQL Code Guard

Didn't find what you were looking for?