Using stored procedures with named parameters

When an Oracle stored procedure is called with named parameters, the name must match the parameter name of the of the Oracle procedure. If the names do not match, a procedure call is made without the named parameter being used and an Oracle error occurs.

NoteIf the parameter name does not match the input parameter name, and the parameter name has a default coded value, the procedure executes using the default value and no error is issued.