Re: Parameters of a store procedure - where into dictionary?

A copy of this was sent to "Sbaiz" <pierluigi.sbaiz_at_elsag.it> (if that email address didn't require changing) On Mon, 28 Jun 1999 15:14:27 +0200, you wrote:

>I'm looking for an Oracle dictionary table/view that
>give me the order of the parameters of a store procedure
>and also the parameter name.
>I think that in the Oracle dictionary this information
>there is somewhere, but I can't find where is it?
>Have your any suggestion ?
>
>Thank in advance
>
>SbaizP.
>
>
>
>

In 7.3 up there is the view 'ALL_ARGUMENTS' and 'USER_ARGUMENTS' that has this.

In all releases there is the dbms_describe package (in plsql) and the odessp OCI function

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Mon Jun 28 1999 - 15:33:07 CDT