I have an updatable view with INSTEAD OF triggers defined. Such views don't support RETURNING clause (ORA-22816: unsupported feature with RETURNING clause), and dotConnect fails to update those views because of generated SQL for update:
Code: Select all
DECLARE
updatedRowid ROWID;
BEGIN
UPDATE TUSERS
SET LASTLOGINTIME = :p0
WHERE ID = :p1 AND TS = :p2
RETURNING ROWID INTO updatedRowid;
OPEN :outParameter FOR SELECT TS FROM TUSERS WHERE ROWID = updatedRowid;
END;
Code: Select all
BEGIN
UPDATE TUSERS
SET LASTLOGINTIME = :p0
WHERE ID = :p1 AND TS = :p2;
OPEN :outParameter FOR SELECT TS FROM TUSERS WHERE ID = :p1;
END;