title: PL/SQL Array Default Null
body: <p>I have a plsql procedure with an html form. The procedure that the submit calls will not always have all variables passed. I would usually put default null for these variables but default null is not working for arrays. Is there any way that I can default the arrays to empty or null to allow the submit to continue?</p>
  
  <pre><code>procedure p_process(
  p_cc_no     varchar2,
  p_pc_no     pc_tm_no_vacant_array, --DEFAULT NULL??
  p_tm_name   name_title_array, --DEFAULT NULL??
  p_tm_no     pc_tm_no_vacant_array, --DEFAULT NULL??
  p_job_title name_title_array, --DEFAULT NULL??
  p_status    status_hrs_shift_array, --DEFAULT NULL??
  p_hrs_per_week  status_hrs_shift_array, --DEFAULT NULL??
  p_shift     status_hrs_shift_array, --DEFAULT NULL??
  p_open      open_delete_array, --DEFAULT NULL??
  p_vacant    pc_tm_no_vacant_array, --DEFAULT NULL??
  p_comments  long_array, --DEFAULT NULL??
  p_delete    open_delete_array, --DEFAULT NULL??
  p_orient    number default null,
  p_ot        number default null,
  p_buy       number default null) is
  </code></pre>