Home » Developer & Programmer » Forms » problem in Execute query
problem in Execute query [message #236588] Thu, 10 May 2007 05:32 Go to next message
shakti_goyal
Messages: 60
Registered: November 2006
Location: India
Member


hello all,
i have developed an Oracle application form which block is based on view . I insert data in the main table of view and it is working properly.. But problem is that It is not able to query the form When i press F11 to enter query and Ctrl+F11 to execute query..
its urgent
Plz give suggession
Regards
Shakti
Re: problem in Execute query [message #236697 is a reply to message #236588] Thu, 10 May 2007 11:39 Go to previous messageGo to next message
Littlefoot
Messages: 20888
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Do you really think that we are mind-readers?

What happens when you execute a query? Does the Sun go supernova? Day turns into night? Oracle returns an error? If so, which one is it? What do you see when you choose Help - Display error from the form menu?
Re: problem in Execute query [message #236920 is a reply to message #236697] Fri, 11 May 2007 05:55 Go to previous messageGo to next message
shakti_goyal
Messages: 60
Registered: November 2006
Location: India
Member

FRM-40301 Query caused no record to be retrived Reenter
After this i collect the SYSTEM.LAST_QUERY and it is executed in Toad fine but in Form It show no record.
I have a list box and text box on my form with some initial value ,But when i deinitialize them Problem is still there..

Plz give suggession
Regards
Shakti

[Updated on: Fri, 11 May 2007 06:14]

Report message to a moderator

Re: problem in Execute query [message #237278 is a reply to message #236920] Mon, 14 May 2007 01:24 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Are you using the same Oracle User in Forms as you as using in TOAD?

David
Re: problem in Execute query [message #237379 is a reply to message #237278] Mon, 14 May 2007 05:27 Go to previous message
shakti_goyal
Messages: 60
Registered: November 2006
Location: India
Member

thanks to everyone who spend his time to solve my problem..
Now problem has solved ..Actually the problem was in some field
which contain more width than existing ...
now all operations are easily performed
Regards
shakti
Previous Topic: Req Answers Detail
Next Topic: You can use it....
Goto Forum:
  


Current Time: Fri Dec 02 18:39:54 CST 2016

Total time taken to generate the page: 0.24028 seconds