title: ORA-01830: date format picture ends before converting entire input string in TOAD
body: <p>I have a script in which I am writing functions and procedures. The script works absolutely fine in Oracle SQL developer without any errors or warnings. This script I have to provide to a client side customer. The customer user runs the same script in <code>TOAD</code> and he gets the error message</p>
  
  <blockquote>
    <p><code>ORA-01830: date format picture ends before converting entire input string</code></p>
  </blockquote>
  
  <p>In this situation, I really don't know how to handle such errors. Is this a bug in <code>TOAD</code>?
  I use <code>to_date</code> and  <code>to_timestamp</code> in my functions and there I get an error.</p>