need to surpressed ORA_20400 error message..
560485Feb 8 2007 — edited Feb 8 2007Let me start from begining.
I have a program unit in a form, which calls DB procedure.
It raises the application error -20400 in some scenrio.
So in the form, I have included an exception block to capture the error. Here I am showing some meaning ful message, which user can understand.
Then in the next step I used RAISE FORM_TRIGGER_FAILURE, which causes 100501: non oracle EXCEPTION. Then I changed RAISE FORM_TRIGGER_FAILURE to RAISE.
Now I could see the message what I am showing to the user. Followed by this getting one more additional message ORA - 20400. But it is not moving further. This is what I wanted.
But the additional message is not getting supressed. Any suggestion how to do so highly appreciated..