ORA-00439: feature not enabled: RETURNING clause from this client

[Janux]

Hi,

Have code like this

OpenDialog1.Title := 'Select file to import';
if not OpenDialog1.Execute then Exit;
fnDPX := OpenDialog1.FileName;
OpenDialog1.Title := 'Select Key file to use for import';
if not OpenDialog1.Execute then Exit;
fnKey := OpenDialog1.FileName;
oraqWork.SQL.Text :=
'insert into work_blob_tmp (id_work_blob_tmp, bytes)' + #13#10 +
'values (null, empty_blob())' + #13#10 +
'returning id_work_blob_tmp, bytes' + #13#10 +
'into :id_work_blob_tmp, :bytes';
oraqWork.Prepare;
oraqWork.ParamByName('id_work_blob_tmp').ParamType := ptOutput;
oraqWork.ParamByName('id_work_blob_tmp').DataType := ftInteger;
oraqWork.ParamByName('bytes').ParamType := ptInput;
oraqWork.ParamByName('bytes').DataType := ftOraBlob;

and it gives subj error on prepare.

Connecting to Oracle 10.1.0.3.0 with ODAC 4.50

[Alex]

It seems to be your Oracle client limitation also you need to know that ODAC with Net options set to True doesn't support BFiles. In all cases pls. specify your Oracle client version and send us small demo project with scripts to create server side objects to ODAC support address.