由买买提看人间百态

topics

全部话题 - 话题: ora0
(共0页)
g*****y
发帖数: 26
1
来自主题: Database版 - ORA0-01422
打开游标时报错,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
来自主题: Database版 - ORA0-01422

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.
(共0页)