Results 1 to 2 of 2

Thread: views error

  1. #1
    Join Date
    Mar 2004
    Location
    london
    Posts
    10

    Unanswered: views error

    hi all
    I have a view that is viewable and updatable from sql HOWEVER when i try to query or execute the same view on forms9i i get the following errors:

    FRM-40505: Oracle Error: unable to perform query
    FRM-40508: Oracle Error: unable to insert record

    any suggestions?
    thanx

    the view is as follows:

    SQL> create view v_student
    2 as select * from student
    3 where upper(USERID) =user;

    View created.

    SQL> grant all on v_student to gellars;

    Grant succeeded.

    --now the user gellars can view or update his/her information only

    SQL> select * from system.v_student;

    STUDENTID FIRSTNAME LASTNAME USERID
    --------- ---------- ---------- --------
    997788554 Sarah Gellar gellars

    --the view is updatable on sql but does not work on forms9i

  2. #2
    Join Date
    Jan 2004
    Location
    Germantown, MD
    Posts
    34
    Use the Display Error Key or Menu Option.

    more info here:
    metalink: 1004134.6
    metalink: 1004142.6

    BTW - metalink has a lot of info on those two FRM errors...

    -Rip
    "The world is a dangerous place, not because of those who do evil, but because of those who look on and do nothing. "
    - Albert Einstein

Posting Permissions

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