TORASql : ORA-22275: le pointeur de LOB indiqué n'est pas valide

[jerduval]

Hello,

We have this error when updating a table with a BLOLB field with the TOraSql component (TOraQuery works fine).

ORA-22275: le pointeur de LOB indiqué n'est pas valide

We are using Delphi XE2 Updt 4 and ODAC 9.4.13

Fields :
FieldKey is Integer not null
FieldValue is BLOB

Code: Select all

OraSql := TOraSql.Create(nil);
try
  OraSql.Session := OraSession;
  OraSql.AutoCommit := false;
  OraSql.Sql.text := 'Insert Into TableTest (FieldKey, FieldValue) Values(:Key, :Value)';
  OraSql.Prepared := true;

  OraSql.Params.ParamByName('Key').AsInteger := 1;
  OraSql.Params.ParamByName('Value').ParamType := ptInput;
  OraSql.Params.ParamByName('Value').DataType := ftOraBlob;
  OraSql.Params.ParamByName('Value').LoadFromStream(TmpStream, ftOraBlob);

  OraSql.Execute;
finally
  OraSql.Free;
end;

Can you tell me what's wrong ?

Regards,

[AlexP]

Hello,

To resolve the problem, you should set the TemporaryLobUpdate property to true like:

Code: Select all

OraSql.TemporaryLobUpdate:= true;

[jerduval]

It works fine, thank you AlexP.
Have a nice end of year !

[AlexP]

Glad to see that the issue was resolved. If you have any further questions, feel free to contact us.