Hello,

i am using Doa 4.0.5, Delphi 7 and Oracale 9i. Our database is configured for unicode support(Session.BytesPerCharacter is set to bcAutoDetect - the function returns 4 Bytes per Character).

When i am using Bind Variables in a TOracleQuery i can not insert strings longer than 1000 characters into a varchar2(4000) field.

Strings longer than 1000 result in an ORA-01480: Nachgestellte Null fehlt bei STR-Bindewert
error.

As i am using only single byte characters in my delphi app (AnsiString) it should be possible to insert more than 1000 characters. (its no problem of the database, as i can insert longer strings with db tools such as Toad)

regards,

walter