Updated on 2022-06-11 GMT+08:00

DBA_PROCEDURES

DBA_PROCEDURES displays information about all stored procedures and functions in the database. It is accessible only to users with system administrator rights.

Table 1 DBA_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