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: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Wed, 05 May 1999 16:08:24 GMT
Message-ID: <37376cca.8434778@192.86.155.100>


A copy of this was sent to "L. Kovács" <office_at_danubit.at> (if that email address didn't require changing) On Wed, 5 May 1999 17:26:41 +0200, you 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.
>

Lets see your pro*c code. give us a really small example that connects, does the insert and exits that reproduces the problem. Sounds like a memory overwrite somewhere in your program.

See http://www.oracle.com/ideveloper/ for my column 'Digging-in to Oracle8i'...  

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA

--
Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Wed May 05 1999 - 11:08:24 CDT

Original text of this message

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