How to declare "nullable" parameters in an Oracle database?

Question

I need my process to accept null values in some parameters of type Number. How do I do this in PL/SQL?

Currently:

PROCEDURE SP_EDITAR_QUADRO(
    P_IDQUADRO IN NUMBER,
    P_IDFUNC IN NUMBER,
    P_IDTRAB IN NUMBER
);
...

I need the parameter P_IDTRAB accepted null values.

Answer 1

You can do it by the operator DEFAULT or :=

PROCEDURE ADD(aNUMBER, b NUMBER, c NUMBER DEFAULT 0)

If you use signature packages remember to replicate the process.

If you want to use it without explicit naming of parameters in calls, you should put your optional parameters at the end of the procedure signatures list.

Read More