Re: Can't insert exactly 2000 chars into VARCHAR2(2000) column

From: <krooss_at_my-dejanews.com>
Date: Sun, 09 May 1999 14:28:54 GMT
Message-ID: <7h4634$c42$1@nnrp1.deja.com>

In article <7gpo44$35l$1_at_fleetstreet.Austria.EU.net>, "L. Kovács" <office_at_danubit.at> wrote:
> Hello,
>
> I want to insert a string exactly 2000 chars long by host variable into a
> VARCHAR2(2000) column from a Pro*C program. The last 20-30 characters get
> garbled from unknown reason. (We can call it the "C2K-problem" :-) The same
> program works fine with strings 1950-1970 chars long. Tried with VARCHAR
> xyz[2000] and char xyz[2000+1] as well. Precompiler: Pro*C for WinNT,
> Version 8.0.5, Server: 7.3.2 RDBMS running on AIX.
>
> Any help would be welcome.
>
>

Hello,

may be it is a problem in the rdbms. We had the same problem with Forms 4.5 and Oracle 7.1.5 on OpenVMS 6.2. It was a bug in the Rdbms, if you have a blocksize of 2000 (normal size) you can't insert/update VARCHAR2 fields with more than 1980 characters. Our solutions was, that we use only 1950 characters of this fields.

I hope this help you,
regards

Juergen Krooss

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Sun May 09 1999 - 09:28:54 CDT