TSQLConnection.GetProcedureNames Method (TWideStrings)

Populates a string list with the names of stored procedures in the database.

Pascal

procedure GetProcedureNames(List: TWideStrings); overload;
procedure GetProcedureNames(const PackageName: Widestring; List: TWideStrings); overload;
procedure GetProcedureNames(const PackageName: WideString; const SchemaName: WideString; List: TWideStrings); overload;

C++

__fastcall GetProcedureNames(TWideStrings List);
__fastcall GetProcedureNames(const BSTR PackageName, TWideStrings List);
__fastcall GetProcedureNames(const BSTR PackageName, const BSTR SchemaName, TWideStrings List);

Description

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:

Copy Code

SQLConnection1.GetProcedureNames(ListBox1.Items);

Copy Code

SQLConnection1->GetProcedureNames(ListBox1->Items);