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.
【在 g*****y 的大作中提到】
: 打开游标时报错，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
: 求救。
|
|
