FireDAC.Comp.Client.TFDCustomStoredProc.StoredProcName
Delphi
property StoredProcName: string read GetProcName write SetProcName;
C++
__property System::UnicodeString StoredProcName = {read=GetProcName, write=SetProcName};
Contents
Properties
| Type | Visibility | Source | Unit | Parent |
|---|---|---|---|---|
| property | public | FireDAC.Comp.Client.pas FireDAC.Comp.Client.hpp |
FireDAC.Comp.Client | TFDCustomStoredProc |
Description
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';