Re: VARCHAR2 Length
From: The Magnet <art_at_unsu.com>
Date: Wed, 9 Dec 2009 08:30:48 -0800 (PST)
Message-ID: <4dbf95cd-4701-4bdb-b15e-1dde332a41d4_at_r40g2000yqn.googlegroups.com>
On Dec 9, 10:24 am, 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.
Date: Wed, 9 Dec 2009 08:30:48 -0800 (PST)
Message-ID: <4dbf95cd-4701-4bdb-b15e-1dde332a41d4_at_r40g2000yqn.googlegroups.com>
On Dec 9, 10:24 am, 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.
Of course I should have said more: What we need to do is put together a dynamic query and open up a cursor:
v_select := 'blah blah blah....'
open p_data for v_select;
v_select is longer than 4000 bytes. Received on Wed Dec 09 2009 - 10:30:48 CST