| duplicate records [message #77886] |
Sat, 08 December 2001 00:50  |
chandrakanth
Messages: 16
Registered: October 2001
|
Junior Member |
|
|
how to check the duplicate unique field before inserting / updating and trape the error message to user named trigger ?
----------------------------------------------------------------------
|
|
|
|
| Re: duplicate records [message #77893 is a reply to message #77886] |
Mon, 10 December 2001 08:37  |
Surendra K
Messages: 8
Registered: September 2000
|
Junior Member |
|
|
Hi Chandrakanth,
While inserting use DUP_VAL_ON_INDEX exception. If there is any duplicate record getting inserted it will raise this exception and you can code your own logic here.
During inserting if this is taken care then there is no quesiton of having duplicate records while updating.
I hope this will help you.
Cheers.
Surendra K
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
