title: How to override >2499 character error in Oracle DB?
body: <p>I have a Oracle query which I'm executing through shell script and in that my query is getting exceeded the maximum length of 2499. </p>
  
  <p>I'm getting error </p>
  
  <blockquote>
    <p>SP2-0027: INPUT IS TOO LONG(> 2499 CHARACTERS) - LINE IGNORED </p>
  </blockquote>