API:FireDAC.Comp.Client.TFDStoredProc.StoredProcName

From RAD Studio API Documentation
Jump to: navigation, search

Delphi

property StoredProcName;

C++

__property StoredProcName = {default=0};

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';

See Also