MY_PROCEDURES

owner

character varying(64)

Owner of a stored procedure, function, trigger, or package.

object_name

character varying(64)

Name of a stored procedure, function, or trigger. This column will be a package name if the object is a function in a package or a stored procedure.

procedure_name

character varying(128)

This column will be the name of a function or stored procedure in a package if object_name is a package name.

object_id

oid

OID of a stored procedure, function, trigger, or package.

subprogram_id

numeric

Location of a function or stored procedure in a package

overload

character varying(40)

The Nth overloaded function

object_type

character varying(13)

Object type.

aggregate

character varying(3)

Specifies whether the function is an aggregate function:

• YES
• NO

pipelined

character varying(3)

Not supported. Its value is NO.

impltypeowner

character varying(128)

Owner of an implementation type.

impltypename

character varying(128)

Name of an implementation type.

parallel

character varying(3)

Not supported. Its value is NO.

interface

character varying(3)

Not supported. Its value is NO.

deterministic

character varying(3)

Not supported. Its value is NO.

authid

character varying(12)

Specifies whether to use the creator permission or caller permission:

• DEFINER: The creator permission is used.
• CURRENT_USER: The caller permission is used.

This column conflicts with reserved keywords. Therefore, add the view name when calling this column.

result_cache

character varying(3)

Not supported. Its value is NULL.

origin_con_id

character varying(256)

Not supported. Its value is 0.

polymorphic

character varying(5)

Not supported. Its value is NULL.

argument_number

smallint

Number of input parameters in a stored procedure.