ORA-01422

ORA-01422

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 : 1. Rewrite your SELECT INTO statement so that only one row is returned. 2. Replace your SELECT INTO statement with a cursor. 3. include exception in your code. More Information Eexception on too many rows returned begin [place your sql statement here] exception when too_many_rows then RAISE_APPLICATION_ERROR(-20001,'Exact Fetch Returned Too many Rows'); end;

Tags: ora-01422,ora-error,oracle error,oracle code,ora error code