Re: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
From: BChase <bsc7080xxmqc_at_myoracleportal.com>
Date: Tue, 08 Jun 2010 06:16:40 -0400
Message-ID: <q26s0656urmr83ptes98ppato3clkp12vr_at_4ax.com>
On Tue, 8 Jun 2010 00:53:28 +0000 (UTC), Mladen Gogala <gogala.mladen_at_gmail.com> wrote:
Date: Tue, 08 Jun 2010 06:16:40 -0400
Message-ID: <q26s0656urmr83ptes98ppato3clkp12vr_at_4ax.com>
On Tue, 8 Jun 2010 00:53:28 +0000 (UTC), Mladen Gogala <gogala.mladen_at_gmail.com> wrote:
>On Mon, 07 Jun 2010 07:43:39 -0700, Sanjeev wrote:
>
>> So, Is there any SQL datatype which will allow more than 4000 character
>> so as to change data type of column 'LocDetail' in LocationDetail table.
>
>CLOB and LONG. LONG is deprecated, both types are a pain in the neck or
>lower.
What about the XML Datatype... its CLOB sized... but formatted XML making it easier to pull data using built-ins. Thoughts ? Received on Tue Jun 08 2010 - 05:16:40 CDT