我在存储过程中select ... into ...时,总是遇到1403和1422错误。100和2112没遇到过。
ORA-00100: no data found Cause: An application made reference to unknown or inaccessible data. Action: Handle this condition within the application or make appropriate modifications to the application code. NOTE: If the application uses Oracle-mode SQL instead of ANSI-mode SQL, ORA-01403 will be generated instead of ORA-00100. ORA-01422: 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 ORA-02112 没查到. 楼主还是装个联机文档.查东西很方便.
你给我解释下不好么?
这里高手也不少阿
TOO_MANY_ROWS 对应 ORA-01422ORA-01422是select .... into ...时返回的记录数太多,无法全部放到 into提供的变量导致。
ora-00100不没有遇到过。
Cause: An application made reference to unknown or inaccessible data.
Action: Handle this condition within the application or make appropriate modifications to the application code. NOTE: If the application uses Oracle-mode SQL instead of ANSI-mode SQL, ORA-01403 will be generated instead of ORA-00100.
ORA-01422: 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
ORA-02112 没查到.
楼主还是装个联机文档.查东西很方便.