SQL Language (MOSC)

MOSC Banner

ORA-00001 unique constraint violated whe using MERGE statement, a bug?

edited Jul 8, 2011 9:23AM in SQL Language (MOSC) 7 commentsAnswered
Hi,

I’m encountering an ORA-00001 unique constraint violated error with a MERGE statement. This statement is implemented in a procedure that had already been executed successfully a dozen times before. Nothing has been changed in the procedure’s code and I can’t figure out why this is happening as there are no duplicates in the source table.

I can reproduce the problem as of now, as the source table’s data is still available.

The MERGE statement is as follows:

MERGE INTO ENG_VENTES_POT_FACT_OP fact_op

USING (SELECT rc_id, gm2, fact_op FROM ENG_VENTES_POT_FACT_OP_TMP) tmp

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center