Re: obtaining the PL/SQL code of packages ??
From: Alex Filonov <afilonov_at_yahoo.com>
Date: 6 Jul 2004 09:32:35 -0700
Message-ID: <336da121.0407060832.6aeead69_at_posting.google.com>
Date: 6 Jul 2004 09:32:35 -0700
Message-ID: <336da121.0407060832.6aeead69_at_posting.google.com>
gelewyc_at_nyct.com (george lewycky) wrote in message news:<68aecc05.0407020849.2448342d_at_posting.google.com>...
> Hello,
>
> I'm trying to find out HOW or WHERE to retrieve the actual PL/SQL code
> of the PACKAGE BODY.
>
> Currently the only means I know of is TOAD's SCHEMA BROWSER.
>
> Any ideas or suggestions would be really appreciated
>
> Thanks
>
> George Lewycky
> http://georgenet.net/oracle
Select text
from all_source
where owner = '<Package owner>'
and type = 'PACKAGE BODY'
and name = '<Package name>'
Received on Tue Jul 06 2004 - 18:32:35 CEST