Re: RAISE_EXCEPTION message customization ?

It appears you are using Forms as the front-end. If you check the Oracle return code variable SQLCODE and find a non-zero value you know an error occurred and you can then display the contents of SQLERRM which you can set in the exception clause of your trigger. You will have to code exception clauses in your triggers that capture the original Oracle error like 'no data found' or 'unique constraint violation' and set the SQLERRM variable and raise a user error or re-raise the original error.

I am not sure you can make these changes since it appears you may be using a vendor (Oracle) application product and I do not know what type of modifications you are allowed to make. But since the application recognizes that an error occurred it may be possible to pass a message back the same way the product does. I would be surprised if the application was using SQLERRM now.

Boaz <boazz_at_wis.weitzmann.ac.il> wrote in article >>
> I wonder if it is possible to customizethe shape of user messages while
> using RAISE_EXCEPTION function in PL/SQL.
> The project is in Oracle Application HR and the version of the database
> is Oracle 8. We tried to add some new data verification functionality to
> the application by using database triggers, but the messages to the user
> are unbearably awkward:

.....
> Is it possible to override it?
>
Received on Mon Jun 08 1998 - 08:07:47 CDT