Hi all.
I have built a Grid Page based on the OEHR_CUSTOMERS_VIEW which is an updatable view.
I know some columns can be updated while others can not.
I just tried to update an update operation and got ORA-01776: cannot modify more than one base table through a join view, which is the expected behavior. Now coming from Oracle Forms background this ca be easily done just by changing some properties.
My question is: What are the alternatives in Apex? Instead of triggers? alter custom code, if so how and where?
Thanks in advance !!!!
