Re: Documenting PL/SQL

From: Paul Boothroyd <paul.boothroyd_at_ntlworld.com>
Date: Fri, 24 Jan 2003 16:04:48 +0000
Message-ID: <3E316420.8090805@ntlworld.com>

The ER design systems that support Stored Procedures and Triggers (in Sybase) tend to add a "flow chart" procedure call ( like a round ended rectangle ):

( NAME )

With lines linking to other S/P's, Functions, and Tables as required, showing calls, Select and Insert/Update/Delete. Packages I would document separately as sub-models. I would probably add the package name to the above function element in some manner.

I hope this helps... a little :-)

Cheers, Paul

bhogak wrote:
> What is the best way to document PL/SQL programs pictorially? UML allows to
> document classes, variables and methods.Is there any such standard diagram
> for PL/SQL? Our documentation is growing bigger and bigger and I was
> wondering what you use?
>
> Thanks
> bhogak
>
>
Received on Fri Jan 24 2003 - 10:04:48 CST