title: Ways to create a procedure with optional parameters?
body: <p>Is that possible to create a procedure with optional parameters?
  For example, create a procedure that add up all of the parameters.</p>
  
  <pre><code>add(n1, n2, .... nn)
  </code></pre>
  
  <p>Another procedure like for example I have 11 parameters, it adds up from 1 to 10, and the last parameter can do something else.
  By googling, it seems like you can use array to do it, but most of the results I got was about another programming languages, not plsql. If apply the theory to plsql I guess I suppose to use varray or nested table?</p>