-
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.
-
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
-
I think that you can use the dba_source to view these informtions.
Sam
Thanx
Sam
Life is a journey, not a destination!
-
what if you need to modify the package? How do you get the package so that you can do the modification?
-
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
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
|