ORA-01422 exact fetch returns more than requested when deleting an object

(Doc ID 329805.1)

Last updated on OCTOBER 27, 2016

Applies to:

Oracle Designer - Version:
This problem can occur on any platform.

"Checked for relevance on 08-Oct-2007"


Multiple copies of PL/SQL objects such as triggers are seen.

Deleting these duplicated objects results in error:
    ORA-1422 exact fetch returns more than requested number of rows.


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms