FRM-40505: Unable\nto perform query The query forms is trying to execute, cannot be performed.
\n
\nThis can either due to missing privileges/permissions or the table/view the block is based on was dropped.
\n
\nCheck the view all_tables and or all_views to see if the table exists, and use the view all_tab_privs to check for the necessary privileges .\n
\n
Forum Messages
earlier the form was based on a table.now i changed it to view.now when i am trying to query on that form it showing error frm-40505 oracle error unable to perform query.
so i want to know if a form is based on view then can i write execute_query to query data from view. |
| : -> 30-JAN-2008 09:39:13 | Possible | DbMotive | Reply |
Yes, this should be possible.
Does the view have the same layout as the table.
Does it have the same column names, the same number of columns.
Is the view owned by a different user than the one you connect with?
If so, did you grant the necessary privileges to the user?
|
Add your message for FRM-40505
|
Home