PostgresDAC

TPSQLDatabase.Methods.GetStoredProcNames

Previous Next

Returns list of stored procedures available at the moment.

Syntax:

procedure GetStoredProcNames(Pattern: String; List: TStrings);

Parameters:

Pattern

Use Pattern parameter to set wildcard matching for procedure names.

List

A string list object, created and maintained by the application, in which the stored procedures names will be return to. Besides, procedures oid's (the unique integer value that represents each procedure) will be returned too. See example.

Description:

Call to GetStoredProcNames to obtain available stored procedures list. Names are schema-qualified, e.g. "schema_name"."proc_name". Strings are sorted by names.

See also:GetStoredProcNames, ServerVersionAsInt, OIDAsInt example