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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Stored procedures, functions and packages

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

Original text of this message

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