CLASS_INSTANCE_PROCEDURES View

This Information Schema view displays a row for each procedure in a class instance.

See also:

CLASS_INSTANCES View, CLASS_INSTANCE_FUNCTIONS View, SHOW PROCEDURES

Columns

Column Name

Data Type

Description

PROCEDURE_NAME

TEXT

Name of the stored procedure.

PROCEDURE_INSTANCE_NAME

TEXT

Name of the class instance to which the procedure belongs.

PROCEDURE_INSTANCE_SCHEMA

TEXT

Name of the schema to which the class instance belongs.

PROCEDURE_INSTANCE_DATABASE

TEXT

Name of the database to which the class instance belongs.

PROCEDURE_OWNER

TEXT

Name of the role that owns the stored procedure.

ARGUMENT_SIGNATURE

TEXT

Type signature of the stored procedure’s arguments.

DATA_TYPE

TEXT

Return value data type.

CHARACTER_MAXIMUM_LENGTH

NUMBER

Maximum length in characters of string return value.

CHARACTER_OCTET_LENGTH

NUMBER

Maximum length in bytes of string return value.

NUMERIC_PRECISION

NUMBER

Numeric precision of numeric return value.

NUMERIC_PRECISION_RADIX

NUMBER

Radix of precision of numeric return value.

NUMERIC_SCALE

TEXT

Scale of numeric return value.

PROCEDURE_LANGUAGE

TEXT

Language of the stored procedure.

PROCEDURE_DEFINITION

TEXT

Stored procedure definition.

CREATED

TIMESTAMP_LTZ

Date and time the stored procedure was created.

LAST_ALTERED

TIMESTAMP_LTZ

Date and time the stored procedure was last altered.

COMMENT

TEXT

Comment for the stored procedure.

Usage Notes

  • The view only displays objects for which the current role for the session has been granted an instance role with access privileges.

Examples

Retrieve the procedures for instances in the mydatabase database:

SELECT procedure_name,
       procedure_instance_name,
       argument_signature,
       data_type AS return_value_data_type
    FROM mydatabase.INFORMATION_SCHEMA.CLASS_INSTANCE_PROCEDURES;
Copy