If you use Entity Framework and the StoreGeneratedPattern for ROWID, ORA_ROWSCN or any other fields (no primary key fields), there is a problem if you have tables available over a database link. This can be done by creating a synonym that points to a table on another oracle database (@dblink).

Devart creates a returning clause for getting values back, but this is not a supported feature with database links and leads into an ora-22816.

Is it possible to implement an option in Devart so that such columns are always read back over a select statement instead of a returning clause? This is not as fast as the returning clause but can help in such a situation.

The select statement should use the key fields (Entity Framework) to get these values back and the key fields must not have the StoreGeneratedPattern property set to get that work.

Example Table:

create table testtable
(
id number primary key,
calculated number,
text varchar2(1000)
)

StoreGeneratedPattern Settings:
Id - None
Calculated - Computed
Text - None

Example PL/SQL:

BEGIN

Insert into testable(id, calculated, text) values (:ID, :CALCULATED, :TEXT);

Select calculated into :OutParameter from testable where id = :ID;

END;