Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: obtaining the PL/SQL code of packages ??

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@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 - 11:32:35 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US