I can not imagine that my problem is so difficult for apex
I have 3 tables and created one view:
CREATE VIEW STAMP_TEST AS
SELECT s.STAMP_ID ,
s.PERSON_ID ,
hp.FULL_NAME,
h.DESCRIPTION
FROM STAMPS s
INNER JOIN EMPLOYEES_IMPORT hp ON s.PERSON_ID = hp.PERSON_ID
INNER JOIN DEPARTMENTS_IMPORT h ON hp.ORGANIZATION_ID = h.ORGANIZATION_ID
after that I created an interactive report with a form but I can not update any of field
Im getting that error:
1 error has occurred
- ORA-22816: unsupported feature with RETURNING clause
Could someone please help me or give me a hint how to add interactive report with form if I have a view with 3 relational databases. It shouldn't be so difficult and it is a common problem I think. I couldnt find any example in the Internet
Im using apex 19