1 2 Previous Next 16 Replies Latest reply: Feb 22, 2013 1:17 PM by 972355 Go to original post RSS
      • 15. Re: ORA-01731: circular view definition encountered
        Aman....
        969352 wrote:
        I AGREE ... READ ONLY CAN'T BE UPDATE.
        READ ONLY means just that: READ ONLY.

        Please explain what it is about READ ONLY that makes you think you should be able to update it.

        I was trying to check
        " How oracle responds when trying to update read-only table ..

        *Oracle throwed following error *
        *ERROR at line 1:*
        *ORA-01733: virtual column not allowed here*

        but i expected error statement like below statement ;

        *Oracle did n't say anything like cannot update a READ ONLY view.*
        but oracle says
        *ORA-01733: virtual column not allowed here*
        That's what the error message is for the read only view!
        http://docs.oracle.com/cd/B10501_01/server.920/a96525/e1500.htm#1002366
        {code}
        ORA-01733 virtual column not allowed here

        Cause: An attempt was made to use an INSERT, UPDATE, or DELETE statement on an expression in a view.

        Action: INSERT, UPDATE, or DELETE data in the base tables, instead of the view.
        {code}

        Had to use the 9i documentation because there is no reference for the error in the 10g, 11g docs.

        Aman....
        • 16. FORCE OPTION in VIEW
          972355
          Good Morning to Everyone ;

          I am sorry to posting here ... thread wrongly posted ..

          org_link : FORCE option in VIEWS
          1 2 Previous Next