title: What is the default size of a varchar2 input to Oracle stored procedure, and can it be changed?
body: <p>I have a stored procedure in Oracle Database 10g where my input is a varchar2 but I'm having issues getting it to run when the input string is long (not sure of exact length maybe > 8000). </p>
  
  <p>My thought is the 'intext varchar2' (as below) is by default is too small.  In other cases where I need a longer string I might define a varchar2 as "intext2 VARCHAR2(32767);" I tried to define the size similarly in the code below but my syntax is incorrect.</p>
  
  <pre><code>create or replace PROCEDURE TESTPROC ( intext IN VARCHAR2
  
  ) AS ....
  </code></pre>
  
  <p>What is the (default) size of the intext varchar2?</p>
  
  <p>Can that size be defined (increased)?</p>
  
  <p>thanks</p>