title: Cannot locate correct line where error is being thrown
body: <p>I have noted from <a href="https://stackoverflow.com/questions/593197/what-is-the-default-precision-and-scale-for-a-number-in-oracle">here</a> that the expected width of a number data type is dynamically set to whatever you need up to a precision of 21 bytes, however I can see in my code that the line </p>
  
  <pre><code>MAX_LENGTH CONSTANT NUMBER := 2000;
  </code></pre>
  
  <p>is throwing the error:</p>
  
  <pre><code>BEGIN
  *
  ERROR at line 1:
  ORA-06502: PL/SQL: numeric or value error: character string buffer too small
  ORA-06512: at "DBAuser.MAKE_VIEWS", line 58
  </code></pre>
  
  <p>Am I misinterpreting the error, or is it possible that the CONSTANT modifier is changing something that I don't expect?  Is there a system level setting which can change the default width of number types?</p>
  
  <p>Edited to reflect more accurate title - issue is that I am looking at what I think is line 58 but it's really not</p>