title: Oracle - How to handle 32K+ string length in variables
body: <p>I am using oracle 11g. Whenever I encountered strings larger than varchar2 size limit, In sql server I use to split the data into multiple variables as below and then join them while execution. However Oracle seems to be expecting 32K combined size before execution. I am getting "ORA-20000: ORU-10028: line length overflow, limit of 32767 bytes per line" error.</p>
  
  <p>I am using these variables in an oralce script (not stored procs). Last 2 statements are throwing the above error and individually I am able to show the value. 
  Thanks in advance.</p>
  
  <pre><code>DECLARE
  
  sViewQuery varchar2(32000);
  sViewSelectQuery varchar2(32000);
  
  BEGIN
  
      ---Assign values of 32,000 letter string (dynamic query)
      sViewSelectQuery:='32K string...';
      sViewQuery:='32K string..';
  
      DBMS_OUTPUT.PUT_LINE(sViewQuery||sViewSelectQuery);
  
      EXECUTE IMMEDIATE sViewQuery||sViewSelectQuery;
  
  END;
  </code></pre>