Re: Help on stored procedure

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 1997/09/30
Message-ID: <3431166e.6547174@newshost>#1/1

On Mon, 29 Sep 1997 17:00:14 +0100, 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 7.2 and 7.3 you have the views user_arguments and all_arguments you can query on to get this information.

In 7.1, the views did not exist but the base tables for the views did. If you look at the table sys.argument$ you can get this information in 7.1

In all versions, there does exist a packaged procedure called dbms_describe.describe_procedure that you may call as well to get this information back in pl/sql tables..

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Bethesda MD

http://govt.us.oracle.com/ -- downloadable utilities

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Tue Sep 30 1997 - 00:00:00 CDT