Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: user defined exception.
I'm not the person to ask Pro*C questions of as I don't like it. Meaning I use it only when forced to: Same with
SQLJ. Others will be far more useful. I like to write all error messages to a table where they can be stored,
reported on, and analyzed. Error messages returned to end-users are generally useless.
Daniel Morgan
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 - 05:49:31 CST