RE: Stored Procedure Parameters

From: Mercadante, Thomas F <NDATFM_at_labor.state.ny.us>
Date: Mon, 24 Sep 2001 08:45:09 -0700
Message-ID: <F001.00396516.20010924083521@fatcity.com>

Manoj,

Look at the USER_ARGUEMENTS or ALL_ARGUEMENTS views.

Interesting enough, there is no DBA_ARGUEMENTS. I wonder why...

hope this helps

Tom Mercadante
Oracle Certified Professional

-----Original Message-----
Sent: Monday, September 24, 2001 11:40 AM To: Multiple recipients of list ORACLE-L

Hi List,

I want to know all parameters of
a specific stored procedure at run time in Code. Can any one tell me ,From where can i get all strored procedure parameters,
information like IN/OUT ,parameter
type(number/varchar2) etc.

TIA...
Manoj.

Do You Yahoo!?
Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger. http://im.yahoo.com
--

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

Author: Soman Manoj
INET: manojdsoman_at_yahoo.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: Mercadante, Thomas F
INET: NDATFM_at_labor.state.ny.us

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