• Data Warehouse Service

dws
  1. Help Center
  2. Data Warehouse Service
  3. Developer Guide
  4. Systems Tables and Views
  5. USER_PROCEDURES

USER_PROCEDURES

USER_PROCEDURES stores 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