Data.SqlExpr.TSQLConnection.GetProcedureNames
Delphi
procedure GetProcedureNames(List: TStrings); overload;
procedure GetProcedureNames(const PackageName: string; List: TStrings); overload;
procedure GetProcedureNames(const PackageName, SchemaName: string; List: TStrings); overload;
C++
void __fastcall GetProcedureNames(System::Classes::TStrings* List)/* overload */;
void __fastcall GetProcedureNames(const System::UnicodeString PackageName, System::Classes::TStrings* List)/* overload */;
void __fastcall GetProcedureNames(const System::UnicodeString PackageName, const System::UnicodeString SchemaName, System::Classes::TStrings* List)/* overload */;
Properties
| Type | Visibility | Source | Unit | Parent |
|---|---|---|---|---|
procedure function |
public | Data.SqlExpr.pas Data.SqlExpr.hpp |
Data.SqlExpr | TSQLConnection |
Description
Populates a string list with the names of stored procedures in the database.
Call GetProcedureNames to retrieve a list of stored procedures in the associated database.
List is a TStrings descendant that receives the stored procedure names. Any existing strings are deleted from the list before GetProcedureNames adds the names of all stored procedures in the database.
PackageName is the name of an Oracle package that contains the stored procedures. This syntax should only be used with Oracle servers when you only want the stored procedures from a specific package.
The following example fills a list box with the names of all stored procedures in the database:
SQLConnection1.GetProcedureNames(ListBox1.Items);
SQLConnection1->GetProcedureNames(ListBox1->Items);