1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

ORA-01733: virtual column not allowed here

Discussion in 'Oracle Forms and Reports' started by saiganesh.pelluri, Mar 29, 2012.

  1. saiganesh.pelluri

    saiganesh.pelluri Active Member

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    55
    I have developed a form and its data sorce in block is a view .when eve i query the find it retrives the data from the view and when i click save it should be saved another table.
    the problem here is iam unable to update the colums in the form .When iam trying to update it is throwing an error like.



    ORA-01733: virtual column not allowed here

    --------------------------------------------------------------
    FRM-40501: ORACLE error: unable to reserve record for update or delete.

    please help me.

    Regards,
    gunny.
     
  2. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi,

    Please check the table whether you are trying to update the field is virtual column or normal column.