Re: Help on stored procedure

From: Dave Deskins <ddeskins_at_net-link.net>
Date: 1997/10/01
Message-ID: <3432DF7D.67F5@net-link.net>#1/1

In SQL*Plus, use the describe command.

SQL> describe get_ename

PROCEDURE get_ename

 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 IN_EMPNO                       NUMBER                  IN
 OUT_ENAME                      CHAR                    OUT

SQL>

Chialin Chou wrote:
>
> Is there a way that I can query the parameter names and the data types
> of a stored procedure?
> Thanks.
>
> Chialin Chou
> ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
> chichou_at_ximage.com
Received on Wed Oct 01 1997 - 00:00:00 CDT