title: SQL proc diagram generating software of a program flow
body: <p>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.</p>
  
  <p>It's not the code I wrote so I don't know the logic enough.</p>
  
  <p>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. </p>
  
  <p>The best approach I see would be flow chart generated from SQL proc with links to "jump" between code and chart. </p>
  
  <p>UPDATE:
  Found couple of software doing the same:</p>
  
  <ol>
  <li><p>ClearSQL - makes CRUD diagrams, call map, and flow chart.</p></li>
  <li><p>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</p></li>
  </ol>