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: 9.0.2.96.6
This problem can occur on any platform.

"Checked for relevance on 08-Oct-2007"

Symptoms

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.

Cause

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