ORA0-01422 - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

ORA0-01422

ORA0-01422# Database - 数据库

g*y2000-12-01 08:12

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*s2000-12-01 08:12

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
: 求救。