title: Oracle error: character string buffer too small
body: <p>I am running a basic query that retrieves rows based on basic conditional clauses, nothing complex.  This works fine:</p>
  
  <pre><code>&lt;cfquery name="courses" datasource="banner"&gt;
          SELECT *
          FROM tjucatalog
          WHERE (course_status = 'Active')
              AND CONCAT(subject,course_no) IN (#PreserveSingleQuotes(courselist)#)
              AND term IN ('Fall 2012')
              AND ((end_date &gt; #now()#) OR (course_meeting_info IS NOT NULL))
          ORDER BY TYear, TSort, DayNum, start_date, time, title
  &lt;/cfquery&gt;
  </code></pre>
  
  <p>However, when I remove the "AND term IN" line from the query, it fails.</p>
  
  <pre><code>&lt;cfquery name="courses" datasource="banner"&gt;
          SELECT *
          FROM tjucatalog
          WHERE (course_status = 'Active')
              AND CONCAT(subject,course_no) IN (#PreserveSingleQuotes(courselist)#)
              AND ((end_date &gt; #now()#) OR (course_meeting_info IS NOT NULL))
          ORDER BY TYear, TSort, DayNum, start_date, time, title
  &lt;/cfquery&gt;
  </code></pre>
  
  <p>The error I get is: <strong>ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at "BANINST1.TJUCATALOG_PACK", line 519</strong></p>
  
  <p>Is this maybe a view that requires the field 'term' to be included, or is there something else at play here I'm entirely unaware of?</p>