Path: news.easynews.com!easynews!sjc-peer.news.verio.net!news.verio.net!newsfeed.berkeley.edu!news-hog.berkeley.edu!ucberkeley!newsfeed.stanford.edu!postnews1.google.com!not-for-mail
From: zekebravo@hotmail.com (Zeke Bravo)
Newsgroups: comp.databases.oracle.server
Subject: Describe procedures in Oracle 8i
Date: 10 Oct 2001 07:35:11 -0700
Organization: http://groups.google.com/
Lines: 20
Message-ID: <522b7e3c.0110100635.5f1d3457@posting.google.com>
NNTP-Posting-Host: 208.248.162.196
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1002724511 6717 127.0.0.1 (10 Oct 2001 14:35:11 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 10 Oct 2001 14:35:11 GMT
Xref: easynews comp.databases.oracle.server:120823
X-Received-Date: Wed, 10 Oct 2001 08:11:28 MST (news.easynews.com)

Oracle 7 allowed you to do a describe on a procedure inside a package,
but you couldn't do a describe for the whole package.  Oracle 8i
implemented a describe for the whole package, but when I try to
describe a procedure inside a package I get the following error:

SQL> DESC CREATE_PEOPLE.CR_PEOPLE
ERROR:
ORA-04043: object CREATE_PEOPLE.CR_PEOPLE does not exist

SQL>

When I do a describe for the whole package it shows all procedures
including the one above.

Is this a setup problem or Oracle dropped the single procedure
describe feature?

Appreciate help with this matter.

Thank you.