PgDAC

TCustomDAConnection.GetStoredProcNames Method

Returns a list of stored procedures from the server.

Class

TCustomDAConnection

Syntax

procedure GetStoredProcNames(List: TStrings; AllProcs: boolean = False); virtual;

Parameters
List
A TStrings descendant that will be filled with the names of stored procedures in the database.
AllProcs
True, if stored procedures from all schemas or including system procudures (depending on the server) are returned. False otherwise.

Remarks

Call the GetStoredProcNames method to get the names of available stored procedures and functions. GetStoredProcNames populates a string list with the names of stored procs in the database. If AllProcs = True, the procedure returns to the List parameter the names of the stored procedures that belong to all schemas; otherwise, List will contain the names of functions that belong to the current schema.

Note: Any contents already in the target string list object are eliminated and overwritten by data produced by GetStoredProcNames.

See Also

© 1997-2024 Devart. All Rights Reserved. Request Support DAC Forum Provide Feedback