Re: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Tue, 8 Jun 2010 00:53:28 +0000 (UTC)
Message-ID: <huk4a8$eov$1_at_news.eternal-september.org>
On Mon, 07 Jun 2010 07:43:39 -0700, Sanjeev wrote:
Date: Tue, 8 Jun 2010 00:53:28 +0000 (UTC)
Message-ID: <huk4a8$eov$1_at_news.eternal-september.org>
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.
-- http://mgogala.byethost5.comReceived on Mon Jun 07 2010 - 19:53:28 CDT