TOracleDirectPathLoader SetData cannot set longer than 1 char

[akaya]

Hi,

I configured loader having 1 column with 100 data size as string. I have tried following variations, none of which was able to load data into database column with more than 1 character. What am I doing wrong?

Delphi 10.1 Berlin, DOA 4.1.3.5, Oracle 11g, OCI 11.1

var
  s : String;
begin
  s := 'S11';
  Loader.Prepare;
  Loader.Columns[0].SetData(0,PChar(s), ByteLength(S));
  Loader.Load(1);
  Loader.Columns[0].SetData(0,PChar(s), Length(S));
  Loader.Load(1);
  Loader.Columns[0].SetData(0,@S[1], ByteLength(S));
  Loader.Load(1);
  Loader.Columns[0].SetData(0,@S[1], Length(S));
  Loader.Load(1);
  Loader.Finish;
end;

Edit: Tried DirectPath Demo with Delphi 7, worked fine. Tried demo with 10.1 Berlin, same 1 char problem exists.

 

[Marco Kalter]

If you declare s as an AnsiString it should work fine.

 

[Airat Khaziev]

Hi there.
But if one will use AnsiString, how then he can load unicode string?

 

[Marco Kalter]

You need to convert it to UTF8 encoding through the UTF8Encode function.

 

[Airat Khaziev]

It helped me. Thank you!