Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: obtaining the PL/SQL code of packages ??
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 - 11:32:35 CDT
![]() |
![]() |