• Data Warehouse Service

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

DBA_SOURCE

DBA_SOURCE stores all stored procedures and functions in the database, along with the columns defined by the stored procedures and functions. It is accessible only to users with system administrator rights.

Table 1 DBA_SOURCE columns

Name

Type

Description

owner

character varying(64)

Owner of the stored procedure or the function

name

character varying(64)

Name of the stored procedure or the function

text

text

Definition of the stored procedure or the function