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

DBA_PROCEDURES

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

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