By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,323 Members | 1,216 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,323 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Jul 19 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.