ORA-01422 Error
We are working on an EDI package. We got the follpowing error:
ORACLE error 20000 in FDPSTP
Cause: FDPSTP failed due to ORA-20000: ORA-01422: exact fetch returns more than requested
ORA-06512: at "XXX_PKG", line 3036
ORA-06512: at line 1
Line 3036 is the last line of the package where an raise_application_error command is invoked.
Here are my questions:
1. What is FDPSTP?
2. Secondly, does the FTPSTP failure have anything to do with the fetch failure.
3. Can this problem be mitigated by simply adding a ROWNUM = 1 line to every SELECT INTO? Or is something else going on that could cause this error to be invoked?