title: How to prompt for user input on PLSQL procedure
body: <p>I'm having trouble getting user input inside of a PLSQL procedure. Everywhere I have looked I've come to the conclusion that is not possible or a PLSQL procedure it not made for user input. </p>
  
  <h2>My code:</h2>
  
  <pre><code>create or replace 
  PACKAGE LAB5 AS
  daysShow NUMBER;
  PROCEDURE show_bizdays2(p_startDate DATE DEFAULT SYSDATE, p_bizDayShow NUMBER);
  
  PROCEDURE show_bizdays2(p_startDate DATE DEFAULT SYSDATE);
  
  FUNCTION Get_Descr(f_sectionId NUMBER) RETURN VARCHAR2;
  
  END LAB5;
  </code></pre>
  
  <h2>Description:</h2>
  
  <p>In this code the first procedure accepts two parameters <strong>a date</strong> and <strong>the amount of business days</strong> to show preceding that date. Works fine.</p>
  
  <p>The second procedure overloads the first and is supposed to be exactly the same however it takes <strong>one</strong> parameter and prompts for the user input in the procedure. Or as described in my notes "ONE input parameter - Start Date and will prompt user to enter how many days are needed to show."</p>
  
  <h2>My Question(s)</h2>
  
  <p>Can you prompt for user input inside of a procedure?</p>
  
  <p>Can I somehow use a global variable in the package that prompts the user when the overloaded procedure is called?</p>