Re: SQL + PL/SQL free impact analysis tool ?

guy.dallaire-nospam_at_criq.qc.ca wrote:

> On Wed, 09 Oct 2002 20:28:09 GMT, Daniel Morgan
> <dmorgan_at_exesolutions.com> wrote:
>
> >
> >Anything wrong with the following?
> >
> >SELECT *
> >FROM all_dependencies
> >WHERE ....;
> >
> >Daniel Morgan
> >
>
> Not exactly what I want. I already have that in TOAD. I need
> aditionnal type of info: What kind of ACCESS to the objects the code
> is doing, is it INSERTING, DELETING, etc...
>
> Note: Please remove -nospam from my e-mail address to reply

[Quoted] Realistically that can not be done. There may be a tool that claims to do it but I will bet it doesn't do it well.

Here's why:

EXECUTE IMMEDIATE 'delete from :x' USING myvar;

Daniel Morgan Received on Thu Oct 10 2002 - 20:02:54 CEST