OraFAQ Forum: Forms » problem in Execute query

Home » Developer & Programmer » Forms » problem in Execute query

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

problem in Execute query [message #236588]

Thu, 10 May 2007 05:32

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

Report message to a moderator

Re: problem in Execute query [message #236697 is a reply to message #236588]

Thu, 10 May 2007 11:39

Littlefoot
Messages: 21826
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?

Report message to a moderator

Re: problem in Execute query [message #236920 is a reply to message #236697]

Fri, 11 May 2007 05:55

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

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Are you using the same Oracle User in Forms as you as using in TOAD?

David

Report message to a moderator

Re: problem in Execute query [message #237379 is a reply to message #237278]

Mon, 14 May 2007 05:27

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

Report message to a moderator

Previous Topic:	Req Answers Detail
Next Topic:	You can use it....

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Sep 27 16:30:58 CDT 2025