title: What exact exception to be caugth while calling TO_DATE in pl/sql code
body: <p>I have below code <code>to_date('1311313', 'yymmdd')</code> which actually throws exception with saying <code>invalid month</code>. Which is can manage as</p>
  
  <pre><code>exception
  when others then
    sop('date format is wrong');
  </code></pre>
  
  <p>Here the problem is everything will get caught which I do not want to do as if some other error will occur then also it will pass the message <code>date format is wrong</code>. I also do not want to create a user defined exception. Just want to know which exception is being thrwon out so that I can use in my code like below</p>
  
  <pre><code>exception
  when name_of_exception then
    sop('date format is wrong');
  </code></pre>