Hi,
I would like to use "mappings" as sub-procedures so I plan to pass input columns with default value.
For example, in PLSQL I write a subprocedure like this:

Procedure P(P1 IN VARCHAR2, P2 IN VARCHAR2 DEFAULT NULL)

So I may call P in 2 ways:
P('param1') or P('param1', 'param2')
and in the first case P2 is not passed and so it is considered null by P.

I try to use mapping to write mapping P with input P1,P2 and a I want some times pass P1 and P2 and other times only P1.

Is it possible doing this without having error? Is there another way to create subprocedures?