Re: long field

From: Lun Wing San <wslun_at_qrcsun.qrc.org>
Date: 1996/11/19
Message-ID: <32921382.369C_at_qrcsun.qrc.org>#1/1

Shuzi Chen wrote:

> I created a table which has a long field. When I tried to insert a
> record into the table, this field still only takes 2000 characters like
> varchar2. If over 2000 chars, it complains 'string literal too long'.
> Any clue.

// *Cause:  The string literal is longer than 2000 characters.
// *Action:  Use a string literal of at most 2000 characters.
//          Longer values may only be entered using bind variables.

-- 
Name        : Lun Wing San
Title       : Oracle developer of the Hong Kong Productivity Council
              System Administrator and Oracle DBA of the Quick Response

Center
Email Addr. : sunny_at_hkpc.org
Telephone : 852-2788-5841 Received on Tue Nov 19 1996 - 00:00:00 CET