I suggest you read up on 'Exceptions' in the PL/SQL book.
There are thousands of examples available via google.
Triggers are just PL/SQL.
On 5/17/05, Kean Jacinta <jacintakean@(protected):
> Hi again
> Can any show me how to catch error in triggers ?
> Let say my system have tis error
> ERROR at line 1:
: 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
> Do you Yahoo!?
> Yahoo! Small Business - Try our new resources site!
Certifiable Oracle DBA and Part Time Perl Evangelist