Procedure Metadata

You are looking at an older version of the documentation. The latest version is found here.

This table supplies information about the procedures in the virtual database.

Column Name	Type	Description
`VDBName`	string	VDB name
`SchemaName`	string	Schema name
`Name`	string	Procedure name
`NameInSource`	string	Procedure name in source system
`ReturnsResults`	boolean	Returns a result set
`UID`	string	Procedure UID
`Description`	string	Description
`OID`	integer	Unique ID

This supplies information on procedure parameters.

Column Name	Type	Description
`VDBName`	string	VDB name
`SchemaName`	string	Schema name
`ProcedureName`	string	Procedure name
`Name`	string	Parameter name
`DataType`	string	Data Virtuality Server runtime data type name
`Position`	integer	Position in procedure arguments
`Type`	string	Parameter direction: "`In`", "`Out`", "`InOut`", "`ResultSet`", "`ReturnValue`"
`Optional`	boolean	Parameter is optional
`Precision`	integer	Precision of parameter
`TypeLength`	integer	Length of the parameter value
`Scale`	integer	Scale of parameter
`Radix`	integer	Radix of parameter
`NullType`	string	Nullability: "`Nullable`", "`No Nulls`", "`Unknown`"
`UID`	string	Procedure UID
`Description`	string	Procedure description
`OID`	string	Unique ID