Home » RDBMS Server » Server Administration » Objects - created by package body
Objects - created by package body [message #64523] Thu, 03 February 2005 17:22 Go to next message
Hesan
Messages: 1
Registered: February 2005
Junior Member
Even though we can get all db 'objects' from db_objects view.
But where does oracle maintain those objects which is created by 'package body' ?

Thanks

Report message to a moderator

Re: Objects - created by package body [message #64524 is a reply to message #64523] Thu, 03 February 2005 21:31 Go to previous messageGo to next message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
In USER_/ALL_/DBA_ARGUMENTS you can find function and procedure definition within a package for the PUBLIC procedures (defined in spec. and body). Those only created in the body (i.e. for internal use in the package body only) will not show.

MHE

Report message to a moderator

Re: Objects - created by package body [message #64525 is a reply to message #64523] Thu, 03 February 2005 21:45 Go to previous message
Sreedhar Reddy
Messages: 55
Registered: January 2002
Member
Check User_Source for packagae name and definition

Report message to a moderator

Previous Topic: number of temporary tablespaces on one oracle database
Next Topic: Diff between ALTER SYSTEM and ALTER DATABASE command
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 27 04:29:14 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.