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: 4516
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: Legacy software
Goto Forum:

Current Time: Sat Aug 19 21:25:09 CDT 2017

Total time taken to generate the page: 0.27940 seconds