Re: Capturing error in trigger

I suggest you read up on 'Exceptions' in the PL/SQL book. There are thousands of examples available via google.

http://www.google.com/search?hl=en&lr=&q=exception+site%3Aasktom.oracle.com&btnG=Search

Triggers are just PL/SQL.

Jared

On 5/17/05, Kean Jacinta <jacintakean_at_yahoo.com> wrote:
>
> 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
>

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

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