Re: Describe procedures in Oracle 8i

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 10 Oct 2001 19:14:24 +0200
Message-ID: <ts91svi16b78ab@news.demon.nl>

"Zeke Bravo" <zekebravo_at_hotmail.com> wrote in message news:522b7e3c.0110100635.5f1d3457_at_posting.google.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.

The latter

Hth,

Sybrand Bakker, Senior Oracle DBA Received on Wed Oct 10 2001 - 12:14:24 CDT