cannot insert into or update data in a view
I have a HR schema in which near about 100 tables. Our application is developed in Forms/Reports 6i.
I have created new schema HR1 and create a view based HR schema tables with simle where condition. i.e.
create view hr1.empsal as select * from HR.empsal where emp_id in
(select emp_id from HR.emp where location <> 'US');
Now when users try to do transaction one transaction able to do successful but when he navigate to next record and try to do another transaction he get the following error :
"cannot insert into or update data in a view"
Tables have master-details relationship.
Thanks in advance,
Thanks for your reply.
I gone through link you have mention and made changes in FORM but now another error comes i.e.
"Record has been updated by another user"
No it is not clear.
I have check v$lock. Only one lock entry found i.e. of user who is trying to do transaction.
Pablo (Paul) Berzukov
Author of Understanding Database Administration
available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Click Here to Expand Forum to Full Width