Home » SQL & PL/SQL » SQL & PL/SQL » how to check the package body information
how to check the package body information [message #316619] Sat, 26 April 2008 10:57 Go to next message
vasantha17
Messages: 10
Registered: April 2008
Location: Hyderabad
Junior Member
Hi All,

Could please help me, which table contains the package body information in a database.

Thanks.
Re: how to check the package body information [message #316620 is a reply to message #316619] Sat, 26 April 2008 11:03 Go to previous messageGo to next message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
user/all/dba_source
user/all/dba_objects

Regards
Michel
Re: how to check the package body information [message #316621 is a reply to message #316620] Sat, 26 April 2008 11:10 Go to previous messageGo to next message
vasantha17
Messages: 10
Registered: April 2008
Location: Hyderabad
Junior Member
Thanks Michel. I checked the all_objects table. But not able to find the TEXT field to check the package body information.

Thanks.
Re: how to check the package body information [message #316622 is a reply to message #316621] Sat, 26 April 2008 11:11 Go to previous messageGo to next message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Now you have it.

Regards
Michel
Re: how to check the package body information [message #316623 is a reply to message #316621] Sat, 26 April 2008 11:17 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

You can also use "dbms_metadata" package.
Previous Topic: tips n tricks document for oracle+performance tuning
Next Topic: How can i login as DBA (merged)
Goto Forum:
  


Current Time: Fri Feb 14 16:33:30 CST 2025