Capturing error in trigger

From: Kean Jacinta <jacintakean_at_yahoo.com>
Date: Tue, 17 May 2005 22:15:21 -0700 (PDT)
Message-ID: <20050518051521.69997.qmail@web52910.mail.yahoo.com>

Hi again

Can any show me how to catch error in triggers ?

Let say my system have tis error
ERROR at line 1:
ORA-00001: unique constraint (PNT.ID_PK) violate

When i try to insert id which existed in database. Can i catch this error and then issue a insert statement

Thank in advanced

JK                 

---

Do you Yahoo!?
Yahoo! Small Business - Try our new resources site! http://smallbusiness.yahoo.com/resources/

--
http://www.freelists.org/webpage/oracle-l

Received on Wed May 18 2005 - 01:19:59 CDT