DBMS Utility.Format Error Stack doens't always work ?

Initially I'd have thought that the DBMS UTILITY.FORMAT ERROR STACK function returned "the error stack" !  

So, If I have a procedure (which calls loads of other procedures) and want the CALLING procedure to report any errors, I expected to be able to just "catch" it in a "when others" exception, then use format error stack to report the error, and continue processing.  

In short, this is driving me nuts (some may say that's too late anyway), but am I missing something obvious ? Or am I just (heaven forbid !) WRONG ?   I'd appreciate any suggestions you may have

Karl

• Sample SQL*Plus output SQL> create or replace Procedure proc c Is 2 Begin 3 raise no data found; 4 End proc c; 5 / Procedure created. SQL> create or replace Procedure proc b Is 2 Begin 3 proc c; 4 End proc b; 5 / Procedure created. SQL> create or replace Procedure proc a Is 2 Begin 3 proc b; 4 End proc a; 5 / Procedure created. SQL> Begin 2 proc a; 3 End; 4 / Begin * ERROR at line 1: ORA-01403: no data found ORA-06512: at "SCOTT.PROC C", line 3 ORA-06512: at "SCOTT.PROC B", line 3 ORA-06512: at "SCOTT.PROC A", line 3 ORA-06512: at line 2

### Good - this was what I expected.
### Now try to catch it in an exception

SQL> Begin
  2 proc a;
  3 Exception When others Then
  4 DBMS Output.Put Line(DBMS Utility.format error stack);   5 End;
  6 /
ORA-01403: no data found

PL/SQL procedure successfully completed.

###' yep - I caught it. BUT WHERE IS THE REST OF THE ERROR STACK !?

-- 
Any ideas out there ?

Karl


--