Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Proc stok of package

Re: Proc stok of package

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Mon, 17 Nov 2003 18:28:37 -0800
Message-ID: <1069122539.843775@yasure>


Anna C. Dent wrote:

> @rennes wrote:
>

>> Hello,
>>
>> How do i know the procedure and function who are in package 'TOTO' ?
>> By a query

>
>
> DESC TOTO
> -- works for 9i DBs
>

Provided you don't care about procedures and functions local to the package body. Provided you don't care about procedures and functions nested inside other procedures and functions. And provided you don't care about code in an initialization block.

Other than that ... works just fine.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Mon Nov 17 2003 - 20:28:37 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US