Devart Forums

Oracle 8.17 + unidac .3.00.0.10 + Delphi 2009

Code:
UniQuery.SQL.Add('Insert Into FileDate (BFile,FileType) Values(EMPTY_BLOB(),:FileType) Returning BFile Into :BFile');
UniQuery.ParamByName('FileType').AsInteger := PIC;
UniQuery.ParamByName('BFile').ParamType := ptInput;
UniQuery.SpecificOptions.Values['TemporaryLobUpdate'] := 'True';
UniQuery.ParamByName('BFile').LoadFromFile(FileName,ftOraBlob);
UniQuery.Execute;

there is a problem with Query.Execute;

ErrorMassage:
'ORA-22275:invalid LOB locator specified
ORA-06512:at "SYS.DBMS_LOB", line 686
ORA-06512:At line 1'

Thanks for the help!

Hello,

To resolve this problem you should set the TemporaryLobUpdate specific option to false.

The problem have solved!
Thank you for help!

Hello,

It is good to see that this problem was solved. If any other questions come up, please contact us.