Re: stored procedure signature?

Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl> wrote in message news:<e4bmgvstrij3o6n084et1eb6v23c0cfe7q_at_4ax.com>...
> On Tue, 08 Jul 2003 18:46:08 GMT, chess hazlett
> <puneyrf_f_unmyrgg_at_enlgurba.pbz> wrote:
>
> >I'm trying to call a stored procedure via sqlplus, and keep getting a
> >"wrong number of types or arguments in call" error. I've been up and down
> >this call, and the thing matches the information I've been given, but I'm
> >not certain that what I've been given is accurate.
> >
> >Is there any way to see the description of a stored procedure (essentially
> >what parameters it takes and returns is all I need) ?
> >
> >Thanks.
> >- chess hazlett
>
> Check out user|all|dba_arguments
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address

Chess, in SQLPLus, you can also just describe a procedure to see the argument list:

UT1> desc trace_sql
PROCEDURE trace_sql

 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 V_SESSION                      VARCHAR2                IN
 V_SERIAL                       VARCHAR2                IN
 V_SWITCH                       VARCHAR2                IN     DEFAULT

Or you can query the all_ or user_arguments views as Sybrand mentioned.

HTH -- Mark D Powell -- Received on Wed Jul 09 2003 - 08:36:06 CDT