473,324 Members | 2,179 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 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 89879
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

15
by: Nick Coghlan | last post by:
Python 2.4's -m command line switch only works for modules directly on sys.path. Trying to use it with modules inside packages will fail with a "Module not found" error. This PEP aims to fix that...
2
by: Kent Lewandowski | last post by:
hi all, Recently I wrote some stored procedures using java jdbc code (admittedly my first stab) and then tried to implement the same within java packages (for code reuse). I encountered...
11
by: seannakasone | last post by:
Is there a way to get the callstack level in c++? for example, take the following code: void call3() { //callstack level would be 3 } void call2() { //callstack level would be 2 call3();
0
by: giovanni gherdovich | last post by:
Hello, first of all: Is this the right place to ask plastek-related questions? I'm trying to make plastex work on my Ubuntu Dapper Drake. For LaTeX, I have the all-in-one package tetex.
12
by: xkenneth | last post by:
All, I apologize if this is a commonly asked question, but I didn't find anything that answered my question while searching. So what I have right now is a few packages that contain some...
9
by: pythonewbie | last post by:
Hi all, I am newbie in Python, my wish would be to create python applications for both Linux/Win32. I am stucked on creating a function to get the Python install directory (and site-packages...
7
by: =?Utf-8?B?Sm9obiBTdGFnZ3M=?= | last post by:
Hello, Please read this all before giving an answer :) I'm doing some troubleshooting on a web application that my company wrote. It's written in asp.net 1.1. The error that the Event viewer...
5
by: John Ladasky | last post by:
Hi folks, Running Python 2.5 on both a Windows XP laptop, and an Ubuntu Linux 7.04 desktop. I've gotten tired of maintaining multiple copies of my personal modules that I use over and over. ...
4
by: george lewycky | last post by:
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...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.