Re: what's more detailed message than SQLERRM

I am using it in an error handler like:

exception when others then
  dbms_output.put_line (dbms_utility.format_error_stack); end;

This is, of course, only for testing, later it should log the error. I have heard by now, that the format_error_stack is quite useless here, it can't deliver the error_stack. This can only be done by client software (forms,sql+,toad,pl/sql developer). Funny enough, it works fine, if the error encountered was raised by a trigger!

--
Posted via http://dbforums.com