DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: cannot insert into or update data in a view

  1. #1
    Join Date
    Apr 2001
    Location
    Vadodara, India
    Posts
    249

    cannot insert into or update data in a view

    Dear All,

    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.

    e.g.

    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,

    Nirav

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334

  3. #3
    Join Date
    Apr 2001
    Location
    Vadodara, India
    Posts
    249
    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"

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    isn't that clear?

  5. #5
    Join Date
    Apr 2001
    Location
    Vadodara, India
    Posts
    249
    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.

    Regards,

    Nirav

  6. #6
    Join Date
    Apr 2001
    Location
    Vadodara, India
    Posts
    249
    Any solution?

  7. #7
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width