Re: ORA-01489 - what the maximum size?

From: DA Morgan <damorgan_at_exesolutions.com>
Date: Wed, 18 Dec 2002 09:18:34 -0800
Message-ID: <3E00ADEA.170C099F@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 Wed Dec 18 2002 - 11:18:34 CST