Re: VARCHAR2 Length

From: The Magnet <>
Date: Wed, 9 Dec 2009 08:30:48 -0800 (PST)
Message-ID: <>

On Dec 9, 10:24 am, 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.

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

Original text of this message