packages, functions,etc

[randy]

Is there any way that I can look look into packages, functions, procedures? e.g. like dba_view that will allow me to look into the contens of a package,functions,etc.

I know it can be done using OEM but currently, I do not have the OEM.

[Oracledba8]

Yes,

Select Text From Dba_Source
Where Owner = Upper('&Owner_name')
and Name = Upper('&NameofPack')
and Type = Upper('&Type');

You need to Know ythe user name if it's not in Your Schema, The Procedure, Function or Package Name.

The Type id Whether it is Procedure, Function, package Body or Package.

You can use User_Source, If it's in Your Schema.

Thanks

[sambavan]

I think that you can use the dba_source to view these informtions.

Sam

[randy]

what if you need to modify the package? How do you get the package so that you can do the modification?

[Oracledba8]

Better to use any Third part Tool, That makes life easier, Otherwise you need to spool the file and save as .sql and make the changes and Compile.

Thanks