Procedure Metadata
SYS.Procedures
This table supplies information about the procedures in the virtual database.
Column Name | Type | Description |
---|---|---|
| string | VDB name |
| string | Schema name |
| string | Procedure name |
| string | Procedure name in the source system |
| boolean | Returns a result set |
| string | Procedure UID |
Description | string | Description set at the Data Virtuality Server |
OriginalDescription | string | Description from the data source |
| integer | Unique ID |
Owner | string | Name of the procedure owner |
ExecuteAs | string | Executor of the procedure (CALLER or OWNER) |
SYS.ProcedureParams
This supplies information on procedure parameters.
Column Name | Type | Description |
---|---|---|
| string | VDB name |
| string | Schema name |
| string | Procedure name |
| string | Parameter name |
| string | Data Virtuality Server runtime data type name |
| integer | Position in procedure arguments |
| string | Parameter direction: " |
| boolean | Parameter is optional |
| integer | Precision of parameter |
| integer | Length of the parameter value |
| integer | Scale of parameter |
| integer | Radix of parameter |
| string | Nullability: " |
UID | string | Procedure UID |
Description | string | Procedure description set at the Data Virtuality Server |
OriginalDescription | string | Description from the data source |
OID | string | Unique ID |