Sysdoc for Oracle PL/SQL and sh source

[petersJazz]

hi,

is there a good tool that can help me in documenting a big system of .sh scripts calling pl/sql packages.

With this tool or guideline I would be able to see what code is not in use any more and to more easily follow what happens as I need to correct some problems in the code.

 

[LKBrwnDBA]

You may need to code the script yourself, perhaps by finding (grep) all scripts that execute "sqlplus".



----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[petersJazz]

Thank you, thats one possability.

But my problem is more on the PL/SQL side where a lot of packages do the job.

 

[LKBrwnDBA]

But my problem is more on the PL/SQL side where a lot of packages do the job.

The issue is that you will need to examine each shell script to figure out if it executes sqlplus and then figure out which PL/SQL procedures/packages are executed.

I know of no utility/tool that would "automate" the task.

One place to begin would be to examine the scripts that are scheduled in the crontab.



----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb