471,092 Members | 1,720 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,092 software developers and data experts.

obtaining the PL/SQL code of packages ??

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
Jul 19 '05 #1
4 89323
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 --
Jul 19 '05 #2
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


Select text
from all_source
where owner = '<Package owner>'
and type = 'PACKAGE BODY'
and name = '<Package name>'
Jul 19 '05 #3
af******@yahoo.com (Alex Filonov) wrote in message news:<33**************************@posting.google. com>...
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


Select text
from all_source
where owner = '<Package owner>'
and type = 'PACKAGE BODY'
and name = '<Package name>'

If you are using Oracle9i, there's also the get_ddl option:

set pagesize 0
set long 90000
SELECT DBMS_METADATA.GET_DDL('PACKAGE_BODY','PK_SOMENAME' ) FROM dual;
set pagesize 0
set long 90000
SELECT DBMS_METADATA.GET_DDL('PACKAGE','PK_SOMENAME') FROM dual;
you can generate pretty much anything using this.

chris
Jul 19 '05 #4
af******@yahoo.com (Alex Filonov) wrote in message news:<33**************************@posting.google. com>...
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


Select text
from all_source
where owner = '<Package owner>'
and type = 'PACKAGE BODY'
and name = '<Package name>'

If you are using Oracle9i, there's also the get_ddl option:

set pagesize 0
set long 90000
SELECT DBMS_METADATA.GET_DDL('PACKAGE_BODY','PK_SOMENAME' ) FROM dual;
set pagesize 0
set long 90000
SELECT DBMS_METADATA.GET_DDL('PACKAGE','PK_SOMENAME') FROM dual;
you can generate pretty much anything using this.

chris
Jul 19 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

15 posts views Thread by Nick Coghlan | last post: by
2 posts views Thread by Kent Lewandowski | last post: by
11 posts views Thread by seannakasone | last post: by
reply views Thread by giovanni gherdovich | last post: by
12 posts views Thread by xkenneth | last post: by
7 posts views Thread by =?Utf-8?B?Sm9obiBTdGFnZ3M=?= | last post: by
5 posts views Thread by John Ladasky | last post: by
4 posts views Thread by george lewycky | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.