Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Can't insert exactly 2000 chars into VARCHAR2(2000) column
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