I'm transferring data from Firebird to Oracle using a parameterized INSERT statement in TOraQuery.
Options.TemporaryLobUpdate = True, using a direct connection.
Hundreds of rows are transferred fine, then all of the sudden, always on the same row, I get an
After that, I get 'no statement parsed'.ORA-01483: invalid length for DATE or NUMBER bind variable
I've ensured the data is always transferred in the same order, to see where it fails. I can't figure out why it fails > before the failing row, larger text blob values are transferred just fine. However, if I modify the contents of the text blob to hold nothing but 'test', it works, but it fails on a later row.
The code used to set the string value is:
Code: Select all
FCommand.Params[Index].ParamType := ptInput;
FCommand.Params[Index].AsOraClob.AsWideString := Value;
Code: Select all
Lob := FCommand.Params[Index].AsOraClob;
Lob.OCISvcCtx := FCommand.Session.OCISvcCtx;
Lob.CreateTemporary(ltClob);
Lob.AsWideString := Value;
Lob.WriteLob;
Lob.FreeTemporary;
With regards,
Martijn Tonies