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 09:14:51 -0800
Message-ID: <1069089314.192444@yasure>


@rennes wrote:

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

All_arguments, as Scott states will give you the contained procedures and functions, but only those available to code written external to the package.

It is not just possible, but common to also code procedures and functions that are local to the package body, procedures and functions nested inside of other procedures and functions, and an initialization section that can not be viewed by any method other than reading the soure code.

-- 
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 - 11:14:51 CST

Original text of this message

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