cannot insert over 4000 chars into LONG field.

cannot insert over 4000 chars into LONG field.

Postby wbjsoft » Fri 30 Oct 2009 05:36

I use dbexpoda.dll 4.40.0.16 using datasnap.

I traced via SQLMonitor.

insert into .......
:3 (String[17609],IN) <- DESCR field LONG type

but the LONG field truncate with 4000 byte.

table descrption follwing :

SVRTDID NOT NULL NUMBER(9)
SVRID NOT NULL NUMBER(9)
LOGTYPE NOT NULL NUMBER(4)
LOGTIME DATE
TOTALUSER NOT NULL NUMBER(9)
TOTALFILE NOT NULL NUMBER(9)
DESCR LONG

cannot insert DESCR field over 4000byte.

please check the problem.
wbjsoft
 
Posts: 6
Joined: Tue 08 Aug 2006 00:38

Postby Plash » Fri 30 Oct 2009 08:25

Maybe you assign a value to the parameter using the AsString property. So that the parameter type is ftString.

Try to use the AsMemo or AsBlob properties instead.
Plash
Devart Team
 
Posts: 2844
Joined: Wed 10 May 2006 07:09


Return to dbExpress driver for Oracle