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!
Oracle Insert Blob error
Thank's AlexP!
The problem have solved!
Thank you for help!
Thank you for help!