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
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 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!

Frank

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


Current Time: Tue Dec 06 13:56:34 CST 2016

Total time taken to generate the page: 0.11756 seconds