Re: string literal too long
From: damorgan <damorgan_at_exesolutions.com>
Date: Fri, 06 Dec 2002 17:03:22 GMT
Message-ID: <3DF0D858.F7B2B2F7_at_exesolutions.com>
Date: Fri, 06 Dec 2002 17:03:22 GMT
Message-ID: <3DF0D858.F7B2B2F7_at_exesolutions.com>
richard2002 wrote:
> I confirmed my edt.text and no end-string char,but 4000 byts string can
> not be written in...
>
> --
> Posted via http://dbforums.com
Assuming you have a version that supports 4K. Try the following:
CREATE TABLE test (
testfld VARCHAR2(4000));
INSERT INTO test VALUES (RPAD('X', 3999, 'X'));
If that doesn't work you have a problem. Otherwise it is your data.
Daniel Morgan Received on Fri Dec 06 2002 - 18:03:22 CET