SQL proc diagram generating software of a program flow
diagram, sql, stored-procedures
Solution
There is a product, Code Visual to Flowchart, which can take code in various languages and do something like what you're describing. Unfortunately though Oracle doesn't appear to be in the list of supported languages, but Microsoft TSQL is; maybe you could at least translate your proc from Oracle into MS and use this to roughly visualize your proc's flow.
Failing that burnall's suggestion sounds like the best way to go, essentially divide and conquer.
Problem
I have a couple of very long procs in Oracle 2000+ lines with lots of calls. And I'd like to generate program flow Diagram (algorithm) for better understanding of the process for further refactoring. It's not the code I wrote so I don't know the logic enough. What would you advise to do in this case? I tried to draw a text-like flow but it takes lots of time and still hard to cover all the logic for understanding. The best approach I see would be flow chart generated from SQL proc with links to "jump" between code and chart. UPDATE: Found couple of software doing the same: ClearSQL - makes CRUD diagrams, call map, and flow chart. Quest SQL Navigator Expert (using it now): it has Outline (makes code flow with ability to collapse-expand blocks of code - really cool one!), Code Explorer (enumerates all func, params with links ti SQL text - just in interface) features