Home » Developer & Programmer » Forms » ORA-00942 & FRM-40505 (Form 10g & R12 )
ORA-00942 & FRM-40505 [message #364492] Mon, 08 December 2008 18:14 Go to next message
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,
Re: ORA-00942 & FRM-40505 [message #364517 is a reply to message #364492] Tue, 09 December 2008 00:03 Go to previous message
Frank Naude
Messages: 4502
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!


Previous Topic: Change the Tab Title
Next Topic: Master detail
Goto Forum:

Current Time: Thu Oct 27 19:58:42 CDT 2016

Total time taken to generate the page: 0.09001 seconds