Re: to Raise or not to Raise, this is the question...

FC wrote:

> Hello there!
> Is there any way to pass a "parameter" to the Oracle error message handler?
> I've seen there are several error messages returning a composite message
> that is clearly made up of fixed text plus the <string> parameter, like
> "ORA-22285 non-existent directory or file for <string> operation".
>
> The only way to mimic internal parameterized messages is using
> Raise_application_error as far as I know.
>
> What if I want to raise the same error passing a value to <string> via a
> standard Raise statement ?
>
> Did I miss something in the docs ?
>
> Thanks,
> Flavio

I'm not sure what it is you are actually asking. So hazarding a guess look at PRAGMA EXCEPTION_INIT. Daniel Morgan Received on Sun Aug 04 2002 - 08:58:20 CDT