Home » SQL & PL/SQL » SQL & PL/SQL » Built in Packages
Built in Packages [message #39686] Fri, 02 August 2002 03:54 Go to next message
Vishnu Vardhan
Messages: 1
Registered: August 2002
Junior Member
There are lots of Built in packages provided by Oracle.
Can any one please let me know that where can I find the documentation
for all these packages.

For most of the built in packages, the documentation are given in
Supplied PL/SQL Packages and Types Reference guide.
For time series, calendar, spacial object, xml, reference to these packages
are in thier reference guide. But I feel still some thing are missing.

For Oracle 9i if I give

select unique(name) from user_source where type='PACKAGE'
for the sys user, its giving me 314 packages.

If I use the entreprise manager to look for these packages,
some of the packages like PRVT_EGUTL, DBMS_RMGR_GROUP_EXPORT are giving
some hexadecimal code which cannot be read.

For the packages, which can be read using the Entreprise Manager, I am able to
use them in the PLSQL Blocks. Can I use these packages, even if they are not
specified in the documentation or is it reserved for internal use i.e use by
some Oracle internal functions?

For those packages, for which the sql code in in unreadable format, is it possible
to use these packages. If so from where can we get the documentation for these
packages.

I also want to know why these packages are in unreadable format. Is they are compiled
packages?

Thanks in Advance,
VishnuVardhan.
Re: Built in Packages [message #39689 is a reply to message #39686] Fri, 02 August 2002 05:02 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
A one stop reference would be to look in the oracle documentation.
look in the documntation manual titled

racle9i Supplied PL/SQL Packages and Types Reference

Re: Built in Packages [message #39693 is a reply to message #39686] Fri, 02 August 2002 07:26 Go to previous message
sverch
Messages: 582
Registered: December 2000
Senior Member
http://technet.oracle.com/doc/oracle8i_816/server.816/a76936/intro4.htm
Previous Topic: 2GB Unix file limit with export
Next Topic: Duplicating Long Raw Datatype Record
Goto Forum:
  


Current Time: Fri Apr 19 20:32:45 CDT 2024