USER_PROCEDURES

Provides information about stored procedures and external procedures.

Provides information about stored procedures and external procedures. Users can only view procedures that they can execute.

Column Name Data Type Description
PROCEDURE_NAME VARCHAR The name of the procedure.
OWNER VARCHAR The owner (definer) of the procedure.
LANGUAGE VARCHAR

The language in which the procedure is defined.

For external procedures, this will be EXTERNAL.

For stored procedures, this will be one of the supported languages.

SECURITY VARCHAR

The privileges to use when executing the procedure, one of the following:

  • DEFINER: Executes the procedure with the privileges of the owner (definer) of the procedure.

  • INVOKER: Executes the procedure with the privileges of the invoker.

For details, see Executing stored procedures.

PROCEDURE_ARGUMENTS VARCHAR The arguments of the procedure.
NAMESPACE_NAME VARCHAR For Eon Mode databases, name of the namespace that contains the procedure.
SCHEMA_NAME VARCHAR

The schema in which the procedure was defined.

If the schema belongs to a non-default namespace in an Eon Mode database, the schema name is front-qualified with the name of the schema's namespace. For example, n1.s refers to schema s in namespace n1.

Privileges

Non-superusers can only view information on a procedure if they have:

  • USAGE privileges on the procedure's schema.

  • Ownership or EXECUTE privileges on the procedure.

Examples

=> SELECT * FROM user_procedures;
   procedure_name   |  owner  | language | security |                               procedure_arguments                                 | schema_name
--------------------+---------+----------+----------+-----------------------------------------------------------------------------------+-------------
 accurate_auc       | dbadmin | PL/vSQL  | INVOKER  | relation varchar, observation_col varchar, probability_col varchar, epsilon float | public
 conditionalTable   | dbadmin | PL/vSQL  | INVOKER  | b boolean                                                                         | public
 update_salary      | dbadmin | PL/vSQL  | INVOKER  | x int, y varchar                                                                  | public
(3 rows)