title: In oracle database, how can I specify default value for a parameter that is a user defined type?
body: <pre><code>    PACKAGE PKG_DEVICE AS 
       TYPE STR_ASSOC_ARR is table of VARCHAR(255) index by BINARY_INTEGER;
       procedure proc_create_device 
  (
    in_deviceid in raw  
  , in_devicecert in clob  
  , in_status in number
  , in_caps in STR_ASSOC_ARR
  , in_vals in STR_ASSOC_ARR
  );
  </code></pre>
  
  <p>is the stored procedure declaration. I would like to specify a default value for the in_caps and in_vals parameters. Is it possible? I am not able to specify <code>default null</code> as it doesn't work. My goal is to not have to pass these two parameters (or pass null) from C# when they are not available. If there is an odp.net way of accomplishing the same, that would work too.<br>
  Using oracle db 11g.</p>