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

On Tue, 08 Jul 2003 18:46:08 GMT, chess hazlett
<puneyrf_f_unmyrgg (AT) enlgurba (DOT) pbz> wrote:

Check out user|all|dba_arguments


Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address

Thanks, Sybrand. That's exactly what I needed.



-chess hazlett

Sybrand Bakker <gooiditweg (AT) sybrandb (DOT) demon.nl> wrote

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 --

Mark.Powell (AT) eds (DOT) com (Mark D Powell) wrote in
news:2687bb95.0307090536.59173c33 (AT) posting (DOT) google.com:

Actually, that was the first thing I tried. I received an "object does not
exist" error.

Anyway, it's good to know that desc is at least *supposed* to work...

Thanks, Mark!