Updated on 2023-04-14 GMT+08:00

USER_PROCEDURES

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

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