This discussion is archived
1 2 Previous Next 16 Replies Latest reply: Feb 22, 2013 11:17 AM by 972355 Go to original post RSS
  • 15. Re: ORA-01731: circular view definition encountered
    Aman.... Oracle ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    Good Morning to Everyone ;

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

    org_link : FORCE option in VIEWS
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points