cannot insert over 4000 chars into LONG field.

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for Oracle in Delphi and C++Builder
Post Reply
wbjsoft
Posts: 6
Joined: Tue 08 Aug 2006 00:38

cannot insert over 4000 chars into LONG field.

Post by 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.

Plash
Devart Team
Posts: 2844
Joined: Wed 10 May 2006 07:09

Post by 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.

Post Reply