Re: Detecting the rowid of the row that caused a unique

From: Mordi <mordi_at_rts.co.il> >>
From a pl/sql program i insert into a table and when i get the ORA-00001 unique constraint error, i need to know which rowid in the table caused the unique constraint error. Why i need the rowid is not the isue now. <<

You have the row that caused the unique constraint violation so from a duplicate value exception block use the uniquely indexed columns to select the rowid. This is about the only way I know to get what you are asking.

Mark Powell -- Oracle 7 Certified DBA
- The only advice that counts is the advice that you follow so follow your own advice - Received on Thu Feb 05 1998 - 00:00:00 CST