title: How to resolve this error Ora-25137 "Data Value Out of range" in oracle
body: <p>How to resolve this error</p>
  <blockquote>
  <p><strong>ORA-25137: Data Value out of range</strong><br />
  <strong>Cause:</strong> value from CAST operand is larger than CAST target size<br />
  <strong>Action:</strong> Increase size of CAST target.</p>
  </blockquote>
  <p>Inside <code>CAST</code> I used one column value having datatype <strong>length 18</strong> and then after compute again I used another <code>CAST</code> to convert its Datatype having same <strong>length 18</strong> but after execute I got an error as I mentioned above. Here is the code:</p>
  <p><code>CAST((CAST(col1 as number(18,0)) * 100)/col2 as varchar(18))</code></p>
  <p>How to resolve this error?</p>