How I can receive SQL statement of the offer which is formed at ApplyUpdates?

vitalkey

Member
I want to work with VIEW on which fire INSTEAD OF trigger. At attempt to make INSERT the server gives out mistake
ORA-22816: unsupported feature with RETURNING clause since the data in the table will be worn out with the trigger and can not return ROWID. How I can redefine SQL text that it did not use design RETURNING RowID INTO:doa __ Rowid?

Best regards, Vitalkey
maito: vitalkey@mail.ru
 
You need to set the UniqueFields property of the dataset to the column name(s) that uniquely identify a record in this view.

------------------
Marco Kalter
Allround Automations
 
Back
Top