Updated on 2026-09-23 GMT+08:00

DBA_SOURCE

DBA_SOURCE displays all stored procedures or functions in the database, and it provides the columns defined by the stored procedures or functions. Only users with system administrator permissions can access this view.

Table 1 DBA_SOURCE columns

Column

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