Re: user defined exception.

Yep. Use it all the time. Problem is that is all it does. It doesn't necessarily communicate any useful information.

Daniel Morgan

Dan Barr wrote:

> Have you looked into the built-in function RAISE_APPLICATION_ERROR?
>
> Hugues Landry wrote:
>
> > Thanks for the answer but...
> > dbms_output does not work for me since i'm making call to the database
> > using OCI call. Because of that i don't see the output send by dmbs_output.
> > I do see the error thrown by oracle ( ORA-nnnnn ). Therefore i wanted to
> > raise an exception that i would not catch. This way i make sure that if
> > someone try to delete from my table not using my method, the execution
> > will stop after rolling back. The only thing left to do is to have a clear
> > error message for my exception.
> >
> > Any thought on this ??
> >
> > Hugues Landry
> >
> > "Daniel A. Morgan" <damorgan_at_exesolutions.com> wrote in message news:<3C4D5E9C.17D42A7E_at_exesolutions.com>...
> >
> >>EXCEPTION
> >> WHEN rtfm THEN
> >> DBMS_OUPUT.PUT_LINE('Another User Did Not RTFM');
> >> WHEN OTHER THEN
> >> DBMS_OUPUT.PUT_LINE('Something Else Happened');
> >>
> >>END;
> >>
Received on Wed Jan 23 2002 - 14:12:18 CST