Re: VARCHAR2 Length

From: Mark D Powell <>
Date: Thu, 10 Dec 2009 06:50:34 -0800 (PST)
Message-ID: <>

On Dec 9, 11:09 am, (Malcolm Dew-Jones) wrote:
> The Magnet ( wrote:
> : So, the max length of VARCHAR2 is 4000 bytes.  So, in PL/SQL, if you
> : need to declare a variable longer than 4000, what can you use?  We
> : need to declare a variable and continue to concatenate strings onto it
> : and it becomes longer than 4000 bytes, so, we're SOL?
> : Still looking for the answer on other sites.
> In PL/SQL max length of VARCHAR2 is much longer than in SQL.

In PL/SQL the maximum length for varchar2 is 32767 which is 7 bytes longer than a PL/SQL long (32760). The PL/SQL data types are distinct from database data types. Though usually very similar in nature there are differences.

PL/SQL functions are also distinct from the SQL functions of the same name.

HTH -- Mark D Powell -- Received on Thu Dec 10 2009 - 08:50:34 CST

Original text of this message