title: What is the max size of VARCHAR2 in PL/SQL and SQL?
body: <p>I am on Oracle 10g. In a requirement I need to increase the size of a pl/sql VARCHAR2 variable. It is already at 4000 size. I <a href="https://stackoverflow.com/a/414949/1529709">have read</a> that </p>
  
  <blockquote>
    <p>in PL/SQL, VARCHAR2 can be up to 32767 bytes. For SQL the limit is
    4000 bytes</p>
  </blockquote>
  
  <p>Can I increase the size of this variable without worrying about the SQL limit?</p>