Home » Developer & Programmer » Forms » ora-01422 (oracle 10g)
ora-01422 [message #285970] Thu, 06 December 2007 04:00 Go to next message
ZX636Rider
Messages: 3
Registered: October 2007
Junior Member
Hello everybody,

I am new in Oracle Developer and i have a problem.
I want to create a form which will take two dates as variables into text_items and with a pressing of button a when button press trigger will bring the results of a query into another text_item.
The problem is that i get the message ora-01422 which means that exact fetch returns more than one row.

Any help?

Report message to a moderator

Re: ora-01422 [message #285975 is a reply to message #285970] Thu, 06 December 2007 04:11 Go to previous messageGo to next message
pablolee
Messages: 2882
Registered: May 2007
Location: Scotland
Senior Member
What exactly is your question? Before answering this, please read and follow the forum guide. here

Report message to a moderator

Re: ora-01422 [message #285976 is a reply to message #285970] Thu, 06 December 2007 04:12 Go to previous messageGo to next message
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
You'll need to further restrict the result data set; it would, probably, require you to include additional condition(s) into the WHERE clause.

Report message to a moderator

Re: ora-01422 [message #285977 is a reply to message #285970] Thu, 06 December 2007 04:12 Go to previous messageGo to next message
yoonus.it@gmail.com
Messages: 109
Registered: June 2007
Location: kuwait
Senior Member
It seems you posted on a wrong forum. You have developer forum for this..try if this helps you!

The message itself is self explanatory. I guess if you are fetching from a table the query is returning more than one row so filter it with a criteria.

Thank you

Report message to a moderator

Re: ora-01422 [message #285979 is a reply to message #285976] Thu, 06 December 2007 04:13 Go to previous messageGo to next message
pablolee
Messages: 2882
Registered: May 2007
Location: Scotland
Senior Member
Littlefoot wrote on Thu, 06 December 2007 10:12

You'll need to further restrict the result data set; it would, probably, require you to include additional condition(s) into the WHERE clause.

Unless of course the OP actually wants potentially multiple rows returned.

Report message to a moderator

Re: ora-01422 [message #285980 is a reply to message #285975] Thu, 06 December 2007 04:14 Go to previous messageGo to next message
ZX636Rider
Messages: 3
Registered: October 2007
Junior Member
the problem is that i don't know what to do with this proble!!
How can display the results from a query into a form??
guide me where i must read to find the answer

Report message to a moderator

Re: ora-01422 [message #285983 is a reply to message #285970] Thu, 06 December 2007 04:20 Go to previous messageGo to next message
yoonus.it@gmail.com
Messages: 109
Registered: June 2007
Location: kuwait
Senior Member
select date into :block1.date from date_tbl;

Report message to a moderator

Re: ora-01422 [message #285990 is a reply to message #285980] Thu, 06 December 2007 04:29 Go to previous message
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Quote:

How can display the results from a query into a form??

Are you sure you want to do it using Forms? Why not Reports instead? A "query" is certainly a wrong source type for a newbie. How about trying to explain what you really need? Could it be done by built-in Forms functionality (i.e. data block created by the Wizard and executing a simple query over the data block based on a table)?

Report message to a moderator

Previous Topic: Block status chages..
Next Topic: Field Validation
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 27 06:19:15 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.