USER_PROCEDURES

USER_PROCEDURES displays information about all stored procedures and functions in the current schema.

Table 1 USER_PROCEDURES columns

Name

Type

Description

owner

character varying(64)

Owner of the stored procedure or the function

object_name

character varying(64)

Name of the stored procedure or the function

argument_number

smallint

Number of the input parameters in the stored procedure