title: How to pass date parameter inside the oracle procedure?
body: <p>Below is the sample procedure code,</p>
  
  <pre><code>create or replace procedure pro_test(start_date date, end_date date)
  is 
  begin
  
  insert into test1 select col1, col2, col3 from main where range_date between start_date and end_date;
  
  exception
  
  &lt; what are the exception I need to capture &gt;
  
  end;
  /
  </code></pre>
  
  <p>Q1 : Is this right way to pass date directly inside the procedure?
  Q2 : If not, can I pass varchar inside the procedure , to convert the date in declaration part?
  Q3 : In begin part am using between operator, can i pass procedure parameter directly ?</p>
  
  <p>While executing this procedure, <code>exec pro_test('10102015','30102015');</code> What i need to mention in between sentence? between start_date and end_date is this enough or i need to mask date format? </p>
  
  <p>can someone help me to clear on this?</p>