Re: VARCHAR2 Length
From: Mark D Powell <Mark.Powell2_at_hp.com>
Date: Thu, 10 Dec 2009 06:50:34 -0800 (PST)
Message-ID: <44a85b53-d89c-4f37-b197-12530d61f6f0_at_n35g2000yqm.googlegroups.com>
On Dec 9, 11:09 am, yf..._at_vtn1.victoria.tc.ca (Malcolm Dew-Jones) wrote:
> The Magnet (a..._at_unsu.com) 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.
Date: Thu, 10 Dec 2009 06:50:34 -0800 (PST)
Message-ID: <44a85b53-d89c-4f37-b197-12530d61f6f0_at_n35g2000yqm.googlegroups.com>
On Dec 9, 11:09 am, yf..._at_vtn1.victoria.tc.ca (Malcolm Dew-Jones) wrote:
> The Magnet (a..._at_unsu.com) 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