-
View package body
What are the tables or views that allow you to see the text content of a package?
--------------------------------------
It's not what the world does to you that matters. It's how you respond...
-
Are you asking about the package, or the package body? One you can see, one you can't.
-
View package
Yes I want to see the code of a package.
--------------------------------------
It's not what the world does to you that matters. It's how you respond...
-
Kind of a road map for you to follow:
desc user_objects
select object_name from user_objects (or all_objects or dba_objects)
where object_type = 'PACKAGE';
Using that name, do
select text from user_source where name = 'NAME YOU JUST FOUND';
You may have to do "set long 2000" (or whatever) to get all of the text to display.
-
Originally posted by stecal
Are you asking about the package, or the package body? One you can see, one you can't.
What do you mean? You can see the code of both the packages and their corresponding bodies. There is no difference between the two in this respect whatsoever.
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
Package bodies are wrapped and you can only see the functional specs. All the code after the header comes out garbled.
-
Originally posted by stecal
Package bodies are wrapped and you can only see the functional specs. All the code after the header comes out garbled.
Are you assuming that he is looking at sys packages? Yes, most of those are wrapped. But the rest can be seen through the views, as you know. I prefer to look at packages using either Enterprise Manager, 9i or DBA Studio 8i. It is a lot easier.
-
Originally posted by stecal
Package bodies are wrapped and you can only see the functional specs. All the code after the header comes out garbled.
As gandolf989 allready mentioned, you've made your conclusion based on wrong assumption .
Package body is garbeled only if the owner has wrapped it.
Besides, even if you are talking only about dictionary packages, you can't say: "you can see (in readable format) specs but you can't see bodies", because it is not true either. There are some DBMS packages that have also their specs wrapped, so you can't read them either.
So again, there is absolutely no difference between package specification and package body when it comes to what can be read from *_SOURCE.
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
Yes, that is correct. I was thinking in terms of what I am used to (our app has all package bodies wrapped). My bad.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|