RE: Stored procedures, functions and packages

From: <LBhat_at_LEVI.com>
Date: Thu, 22 Feb 2001 01:02:01 -0800
Message-ID: <F001.002BA48B.20010222002544@fatcity.com>

You can use describe in SQL*Plus to look at the arguments (parameters) only.

HTH
- Bhat

                -----Original Message-----
                From:   Carlos Porras [mailto:cporras_at_ArtInSoft.com]
                Sent:   Thursday, February 22, 2001 7:01 AM
                To:     Multiple recipients of list ORACLE-L
                Subject:        Stored procedures, functions and packages 

                Hi all, Gurus.  Is there a view or synonym that stores the
declaration part
                of procedures, functions and/or packages?.  That is,
something like
                SYS.argument$, user_arguments or all_arguments (useful for
example to access
                the arguments of stored procedures and functions in an easy,
structured
                way), but in this case of course only related to variables,
types,
                constants, etc.  (that is, the declaration part within the
stored
                procedures, functions and packages)?  

                Thanks a lot.

                -- 
                Please see the official ORACLE-L FAQ: http://www.orafaq.com
                -- 
                Author: Carlos Porras
                  INET: cporras_at_ArtInSoft.com

                Fat City Network Services    -- (858) 538-5051  FAX: (858)
538-5051
                San Diego, California        -- Public Internet access /
Mailing Lists
        
--------------------------------------------------------------------
                To REMOVE yourself from this mailing list, send an E-Mail
message
                to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru')
and in
                the message BODY, include a line containing: UNSUB ORACLE-L
                (or the name of mailing list you want to be removed from).
You may
                also send the HELP command for other information (like

subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
  INET: LBhat_at_LEVI.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Feb 22 2001 - 03:02:01 CST