Re: VARCHAR2 Length

From: The Magnet <art_at_unsu.com>
Date: Wed, 9 Dec 2009 09:02:17 -0800 (PST)
Message-ID: <4e120582-bb7f-4121-a2eb-9392a1c0ebd7_at_r5g2000yqb.googlegroups.com>

On Dec 9, 10:50 am, joel garry <joel-ga..._at_home.com> wrote:
> On Dec 9, 8:30 am, The Magnet <a..._at_unsu.com> wrote:
>
>
>
> > 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.
>
> Wellll...http://awads.net/wp/2007/05/31/did-you-know-that-about-plsql-variables/
>
> Sounds like a job for a Character Large OBject.
>
> http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14249/adlob_...
>
> And poke around in asktom.  Looks like what you want to do (cursor
> +clob) is limited to 11g:http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:4...
>
> Remember, a lot of these things are version dependent, so be real
> specific about your environment.  Those of us drowning in the stream
> of consciousness may not remember even if you just told us.
>
> jg
> --
> _at_home.com is bogus.http://www.signonsandiego.com/news/2009/dec/08/how-fake-sites-trick-s...

My total bad, we're running Oracle 10g R2. But I'll take a look at the docs. Thanks for the references. Received on Wed Dec 09 2009 - 11:02:17 CST