How to hide ORA-06512 and ORA-04088 error messages?

[Galina]

Hello
I have created a trigger not to let records with certain fields null
to be inserted into the table:
BEGIN
IF :new.RUL_CODE is null or
:new.FES_UINS_CODE is null or
:new.FES_UIO_CALOCC is null then
RAISE_APPLICATION_ERROR(-20000,'Record is not saved. Check course
record and try to save again.');
end if;
end;

The trigger is set to fire before insert.

The trigger does the trick preventing the record to go into the table,
but besides my error message it shows also ORA-06512 and ORA-04088
errors, which I’d prefer my users not to see. I found numerous
opinions that these messages are OK. One of the answers in this ng:
“It's normal situation. Your trigger raise application error.
You need define exception entry for this error in block where you
enter INSERT statement.
With best regards, Igor Kirasirov”

How to define exception entry? How to hide ORA-06512 and ORA-04088
error messages?

Thank you for your help.
Galina

[Daniel Roy]

It's not really possible in SQL*Plus. Take a look at
"http://asktom.oracle.com/pls/ask/f?p=4950:8:6890696327207967146::NO::F4950_P8_DISPL AYID,F4950_P8_CRITERIA:195612348072,"
for Tom Kyte's explanation as to why.

Daniel

Hello
I have created a trigger not to let records with certain fields null
to be inserted into the table:
BEGIN
IF :new.RUL_CODE is null or
:new.FES_UINS_CODE is null or
:new.FES_UIO_CALOCC is null then
RAISE_APPLICATION_ERROR(-20000,'Record is not saved. Check course
record and try to save again.');
end if;
end;

The trigger is set to fire before insert.

The trigger does the trick preventing the record to go into the table,
but besides my error message it shows also ORA-06512 and ORA-04088
errors, which I’d prefer my users not to see. I found numerous
opinions that these messages are OK. One of the answers in this ng:
“It's normal situation. Your trigger raise application error.
You need define exception entry for this error in block where you
enter INSERT statement.
With best regards, Igor Kirasirov”

How to define exception entry? How to hide ORA-06512 and ORA-04088
error messages?

Thank you for your help.
Galina