ORA-01422: exact fetch returns more than requested number of rows
475922Feb 15 2006 — edited Feb 15 2006Good Morning Everyone!
When my proc is getting to this startment its giving me the error below:
UPDATE TT_FERMS
SET assigned_system_id = 2
WHERE ferm_bank = 3
RETURNING ( SPAC_ASSIGN_FERMS.xfer_seq + 1 ), SPAC_ASSIGN_FERMS.xfer_seq
+ 1 INTO SPAC_ASSIGN_FERMS.xfer_seq, SPAC_ASSIGN_FERMS.xfer_seq;
ERROR:ERROR at line 1:
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "BREW_SCHED.SPAC_ASSIGN_FERMS", line 959
Please help!
Thanks much!