Thanks a bunch!
"Ken Denny" <ken_at_kendenny.com> wrote in message
news:Xns92318FEFC4319kendenny_at_65.82.44.7...
> "Aaron Jaque" <aaron.jaque_at_cybersurf.net> wrote in
> news:3d0f7568$1_2_at_news.cybersurf.net:
>
> > I'm trying to raise an exception when an integrity constraint is
> > violated. I can catch the error with the "WHEN OTHERS" exception, but I
> > want to catch the specific error individually. The error looks like
> > this: ERROR at line 1:
> > ORA-02291: integrity constraint (SCHEMA_NAME.CONSTRAINT_NAME) violated
> > - parent key not found
> > ORA-06512: at "SCHEMA_NAME.PACKAGE_NAME", line 82
> > ORA-06512: at line 1
> >
> > Is there a way to catch this specific error, maybe by number?
>
> DECLARE
> parent_not_found EXCEPTION;
> PRAGMA EXCEPTION_INIT (parent_not_found, -2291);
> BEGIN
> ...
> EXCEPTION
> WHEN parent_not_found THEN
> ...
> END;
>
> This defines the exception name Parent_not_found and associates it with
> the error number -2291. You can then use the exception name in your
> EXCEPTION section.
>
> --
> Ken Denny
> http://www.kendenny.com/
>
> 42.7 percent of all statistics are made up on the spot.
>
Received on Tue Jun 18 2002 - 14:58:30 CDT
