FWIW what I propose is consistent with what most JDBC drivers do; not sure if this behavior is required specifically. In order for a argument default on a procedure to be applied it must not be referenced. It is similar to DEFAULT values on columns.