SQL & PL/SQL

Hi everyone,

I have a question reagrding the last parameter in the raise_application_error clause.

The last parameter says
true: purge error stack
false: do not purge error stack.

I raised an exception and captured it with both parameters.
In the case of false(do not purge previous errors) I could see the exect error no and msg (like No data found).
But in the case of true (purge previous errors) i got an exception, but not the exact error msg.


Is this the difference.
In the case of true, it should purge previous errors, why is it purging the most recent error also.
Is there anything more to true and false. Please highlight.

And is there a way i can see the error stack.
I am so keen to see that.
It always says error is placed on the stack of previous errors.
I want to see the previous errors.
Can I.

Any ideas.

meenakshi