how to list the contents of a package

[vicentealeman]

I would like to know if there is any way to list what is in a package or a package body ?

I have a problem compling one but I can not see what is in there?
Thanks

 

[sem]

select line, text from user_source where type='PACKAGE BODY' and name = '<PACKAGE NAME >' order by 1

Regards, Dima

http://seminihin.narod.ru

 

[vicentealeman]

sorry but what should I use for user_source?

 

[sem]

user_source is a view name. You should replace <PACKAGE NAME > with your real package (don't forget about uppercase)

Regards, Dima

http://seminihin.narod.ru

 

[vicentealeman]

uPPPS BUT THIS THE ONLY THING IT SHOWS...

LINE
==========

0 ROWS SELECTED

 

[sem]

This means that either you've specified package name incorrectly or have no access to its body (package doesn't belong to you). Try to investigate DBA_SOURCE (if you have that right) instead of USER_SOURCE.

Regards, Dima

http://seminihin.narod.ru

 

[vicentealeman]

Thanks it worked..
It is possibly to copy the package(s) from one instance to another?