Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Can't insert exactly 2000 chars into VARCHAR2(2000) column

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

From: Stephan Gliem <gliem_at_tfh-berlin.de>
Date: Sun, 09 May 1999 19:33:10 +0200
Message-ID: <3735C6D6.3A2D0B36@tfh-berlin.de>


As far as I remember there was a workaround for server version 7.x suggested by Oracle: Set the block size to e.g. 4k, this would also prevent the strange behaviour of certain select statements containing varchar(2000) columns.

Stephan

krooss_at_my-dejanews.com wrote:
>
> 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 - 12:33:10 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US