Re: How list supplied packages

From: Hans Forbrich <forbrich_at_telusplanet.net>
Date: Tue, 05 Aug 2003 01:54:30 GMT
Message-ID: <3F2F0C53.65D65939@telusplanet.net>

Randy Nichols wrote:

> Is there a way to list the supplied packages currently available in an
> installation using SQL*PLUS?

Please define 'list'. Just the names or the contents?

Note that in Oracle9i there are wonderful document called "Supplied Java Packages Reference" and "Supplied PL/SQL Packages and Types Reference" that provide some detail about what could be installed.

One minor gotcha is that some of the packages are not installed under userid SYS and possibly not under SYSTEM.

Have you checked the DBA_OBJECTS view for your DB version? Received on Mon Aug 04 2003 - 20:54:30 CDT