API:FireDAC.Comp.Client.TFDStoredProc.StoredProcName
Delphi
property StoredProcName;
C++
__property StoredProcName = {default=0};
Contents
Properties
Type | Visibility | Source | Unit | Parent |
---|---|---|---|---|
property | published | FireDAC.Comp.Client.pas FireDAC.Comp.Client.hpp |
FireDAC.Comp.Client | TFDStoredProc |
Description
Identifies the name of the stored procedure on the server to call.
FireDAC.Comp.Client.TFDStoredProc.StoredProcName inherits from FireDAC.Comp.Client.TFDCustomStoredProc.StoredProcName. All content below this line refers to FireDAC.Comp.Client.TFDCustomStoredProc.StoredProcName.
Identifies the name of the stored procedure on the server to call.
Set StoredProcName to specify the name of the stored in database procedure to call. The full name of the stored procedure will be build from the CatalogName, SchemaName, PackageName, Overload property values. A full name can also be assigned to StoredProcName (only for non-packaged procedures). If the name is case sensitive or contains special characters, then it must be explicitly quoted.
If the database does not have a stored procedure with the StoredProcName name, then when the application attempts to prepare the stored procedure, an exception is raised.
Example
//Example 1:
ADStoredProc1.StoredProcName := 'Northwind.dbo.[my proc]';
// the same as following
ADStoredProc1.CatalogName := 'Northwind';
ADStoredProc1.SchemaName := 'dbo';
ADStoredProc1.StoredProcName := '[my proc]';
//Example 2:
ADStoredProc1.PackageName := 'sys.dbms_sql';
ADStoredProc1.StoredProcName := 'execute';