Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: ORA-01489 - what's the maximum size?
Yes, Daniel knows that, and that's why he answered like he did;-)
When you concatenate columns they are converted to VARCHAR2, and so the
2k/4k upper limit applies. You can use PL/SQL to have a higher upper limit.
Peter
"Reinhard" <Reinhard_nospam.Wahl_at_gmx.de> schreef in bericht
news:atrta1$213fb$1_at_ID-119204.news.dfncis.de...
> Hi Dan,
>
> thanks, but I ment the output size in SQL*Plus when I concatenate the
> columns
> like:
>
> SELECT RPAD(COL_A_TEXT, 100)||LPAD(TO_CHAR(COL_B_NUM),10)||...
> FROM Table_X;
>
> Regards
> Reinhard
> --------------------------------------------------------------
> For direct reply please remove _nospam from address
> "DA Morgan" <damorgan_at_exesolutions.com> schrieb im Newsbeitrag
> news:3E00ADEA.170C099F_at_exesolutions.com...
> > Reinhard wrote:
> >
> > > Hi there,
> > >
> > > I tried to select a table by concatenation of the fields with fixed
> record
> > > length via SQL*Plus
> > > and I got the the ORA-01489 error.
> > >
> > > What's the maximum size of a concatenated string?
> > > Can I change SQL*Plus settings to succeed?
> > >
> > > Thanks in advance
> > > --
> > > Reinhard
> > > --------------------------------------------------------------
> > > For direct reply please remove _nospam from address
> >
> > Depends on your version which you don't mention.
> >
> > Currently VARCHAR2 is 4K in tables and 32K in variables.
> >
> > Dan Morgan
> > http://www.extension.washington.edu/extinfo/certprog/oad/oad_main.asp
> >
>
>
>
>
Received on Thu Dec 19 2002 - 01:48:12 CST