From: Wassili Kazakos <kazakos@fzi.de>
Subject: LONG to long in Oracle?
Date: 1998/02/02
Message-ID: <34D61AE0.399667D3@fzi.de>#1/1
Content-Transfer-Encoding: 7bit
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
X-Complaints-To: usenet@nz12.rz.uni-karlsruhe.de
X-Trace: nz12.rz.uni-karlsruhe.de 886446857 4483 (None) 141.21.4.53
Organization: University of Karlsruhe, Germany
Newsgroups: comp.lang.java.databases,comp.databases.oracle.misc



Hi,

I'm trying to store a long text (grater than 2000 chars) in an Oracle
DB, but I get the message ORA-01704 String literal to long. The
explanation is "quoted strings may not contain more than 2000
characters". Does this make sense? Is there an other possibility to
store long text files in a LONG field? Or have I to cut it in 2000 CHAR
pieces?

I try to do this from an java application, but I get the same error with
sqlplus...

thanks in advance
Wassili