g*****y
发帖数: 26 | 1 打开游标时报错，oerr 显示
01422, 00000, "exact fetch returns more than requested number of rows"
// *Cause: The number specified in exact fetch is less than the rows returned.
// *Action: Rewrite the query or change number of rows requested
但这个查询以前是能通过的。而且，数据量也不大。 <10000
求救。 |
|
p****s
发帖数: 3184 | 2
The possible reason could be that you have a SELECT ... INTO statement.
Before long there is only 1 tuple qualified by WHERE clause. As you
just inserted some new tuples, now there are more than 1 tuples qualified.
Then SELECT INTO can't handle it, you must use cursor now. |
|
c*****a
发帖数: 1728 | 3 三个table：clients, orders, order_items.
一个client可能有多个order，
一个order可能有多个order item。
用一个oracle form来显示全部信息，用三个data block分别对应这三个table。
query的时候会有ora-01422 error。
如何解决这个问题，谢谢了！ |
|
