OraFAQ Forum: Forms » LOV display problem

Home » Developer & Programmer » Forms » LOV display problem

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

LOV display problem [message #83689]

Fri, 28 November 2003 01:53

Jasmine
Messages: 23
Registered: December 2000

Junior Member

hi
i created an lov but its not diplsaying
while executing the query it showing an error

frm -40505 :oracle error unbale to perform query
what's the wrong wheter i have to make any change in record group
thanks in advance
jasmine

Report message to a moderator

Re: LOV display problem [message #83692 is a reply to message #83689]

Fri, 28 November 2003 04:53

Frank Naude
Messages: 4579
Registered: April 1998

Senior Member

Hi,

FRM-40505: ORACLE error: unable to perform query.

Cause: Oracle Forms has encountered a processing error. The table associated with the current block of the form might not exist, or your username might not have authority to perform the specified action on the table.

Action: Pressing [[Display Error]] provides more information, if it is available. You can also try to update or delete this record later. If necessary, contact your DBA.

Best regards.

Frank

Report message to a moderator

Re: LOV display problem [message #83693 is a reply to message #83692]

Sat, 29 November 2003 08:02

Jasmine
Messages: 23
Registered: December 2000

Junior Member

Desr sir
i given the appropriate privileges but the erorrs is there how to debug
it and no dba in our firm.i used many ways which key we have to press is it ctr + d or etc..
when ia m not connecting lov its working i am populating the records with post query trigger
the code is correct
how to catch the error
i wrote on error but no use
pls hlp
jasmine

Report message to a moderator

Re: LOV display problem [message #83708 is a reply to message #83689]

Tue, 02 December 2003 19:18

Rengaprabhu
Messages: 18
Registered: August 2002

Junior Member

Execution error - Check all the columns in your block are related to the table. If you found any items not related to the table then make the database item property to no.

Lov - Check the query in sql for the particular condition.

Report message to a moderator

Re: LOV display problem [message #83724 is a reply to message #83689]

Wed, 03 December 2003 17:37

Lars O Sjöström
Messages: 25
Registered: May 1999

Junior Member

Where in the code are you displaying the LOV? In what way?

Report message to a moderator

Re: LOV display problem [message #83971 is a reply to message #83689]

Sun, 11 January 2004 18:36

prashant
Messages: 122
Registered: September 2000

Senior Member

Before doing the set_block_property clear the form using novalidate and then assign the defaultwhere value to the block and then execute query.

aslo check whether ur column mappings r correct. Try using a global variable for quering

thanks
prashant

Report message to a moderator

Previous Topic:	logon screen
Next Topic:	forms9ids forms service error & urgent

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 22:40:10 CDT 2024