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@xxxxxxxxx> 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

Other related posts: