ge*****@nyct.com (george lewycky) wrote in message news:<68**************************@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
Just about everything related to objects created in Oracle is
available via the dictionary: all_, dba_, and user_source. Only the
owner or a DBA can see the source for a package body but if you have
execute privilege on the package you can see the specification source
via these views as long as the source was not wrapped. If the source
is wrapped you are pretty much out of luck if you do not have the
source stored away somewhere.
HTH -- Mark D Powell --