Re: Capturing error in trigger
- From: Jared Still <jkstill@xxxxxxxxx>
- To: jacintakean@xxxxxxxxx
- Date: Wed, 18 May 2005 15:20:52 -0700
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/
> --
> //www.freelists.org/webpage/oracle-l
>
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
//www.freelists.org/webpage/oracle-l
Other related posts:
