title: How can I set an oracle procedure's parameter default to the result of a select?
body: <p>I have an oracle Procedure and I want to set the default parameter to the result of a select statement such as below.</p>
  
  <pre><code>procedure foo( startID number : = max(x.id) from xtable x )
  </code></pre>
  
  <p>but the code above is illegal syntax.</p>