yk156511 发表于 2022-1-26 15:34

SQL



怎么显示出具体哪些bdcdyh报错的啊 语句论坛上发不出来。试了几次

LingPing 发表于 2022-1-26 15:39

第一个select into 只能有一条值   程序返回的可能是多条

大白痴先生 发表于 2022-1-26 18:38

By default, a SELECT INTO statement must return only one row. Otherwise, PL/SQL raises the predefined exception TOO_MANY_ROWS and the values of the variables in the INTO clause are undefined. Make sure your WHERE clause is specific enough to only match one row.

Solution:
Improve the Where clause of your first SELECT INTO statement at line 11.

黑白 发表于 2022-1-26 21:40


框出来的都存在多条可能,如果只需要一条就加限制条件,如果存在多条sjhqsj = 改成 sjhqsj in
页: [1]
查看完整版本: SQL