Re: Software to Generate PL/SQL Call Stack??

rajbrown_at_gmail.com wrote:
> Hello - I might be living in cloud cuckoo land, but I'm wondering if
> there's any way to generate documentation on a PL/SQL package which
> will display the full call stack. I imagine it would need some 3rd
> party software to parse the source code to display it, but I could be
> wrong. Ideally I'd like something generated such as this:
>
> p_process
> -> f_get_name
> -> f_validate
> -> p_do_some_stuff
> -> p_get_going
> -> p_insert_some_records
> -> p_delete_everything
> -> f_check_nothing exists
>
> etc, etc.Hope that makes sense! I've pondered trying to write my own,
> but I think it could take some time! If such a thing exists, it would
> really help me with documenting my code and assist with exception
> handling.
>
> Thanks!

Take a look at DBMS_UTILITY.FORMAT_CALL_STACK.

You can find syntax at http://tahiti.oracle.com and a demo of its use in Morgan's Library at www.psoug.org. Click on Exception Handling.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)