| ORA-00942 & FRM-40505 [message #364492] |
Mon, 08 December 2008 18:14  |
ajay_orcl
Messages: 5
Registered: November 2008
|
Junior Member |
|
|
Hi All,
I'm getting an error[ORA-00942 & FRM-40505] when I click on the query find button on my custom form.
ORA-00942: table or view does not exist.
FRM-40505: ORACLE error: unable to perform query.
Is this error has any thing to do with the privileges of my objects[table/view] which i'm using in the form or is it some thing else?
Thanks & Regards,
Ajay
|
|
|
|
| Re: ORA-00942 & FRM-40505 [message #364517 is a reply to message #364492] |
Tue, 09 December 2008 00:03  |
Frank Naude
Messages: 4589
Registered: April 1998
|
Senior Member |
|
|
Well you need to create the table or view in the user/schema that FORMS log in to, or grant the required object privileges to that user.
It may also be that access was granted, but you don't use qualified names (i.e. schema.table). You can always create synonyms if you don't want to qualify the object names.
Best of luck!
Frank
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
