Re: Help on stored procedure

From: Ms. D.H. Harvey <qq45_at_liverpool.ac.uk>
Date: 1997/10/03
Message-ID: <EHHAv2.F5u@liverpool.ac.uk>#1/1

Chialin Chou (chichou_at_ximage.com) 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

In V7.1.6 can do following when in SQL*Plus (assume should be OK with higher versions):

Ordinary procedure describe <procedure name>

Package procedure describe <package name>.<procedure name>

Hope this helps. Helen Received on Fri Oct 03 1997 - 00:00:00 CDT