TADCustomStoredProc.StoredProcName Property

Identifies the name of the stored procedure on the server to call.

Group

Links

TADCustomStoredProc Class, TADCustomStoredProc Members, uADCompClient Namespace, Example 1, Example 2, public, See Also

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 CatalogName, SchemaName, PackageName, Overload property values. Also a full name may be assigned to the StoredProcName (only for non-packaged procedures). If name is case sensitive or contains special characters, then it must be explicitly quoted.

If database does not have stored procedure with StoredProcName name, then when the application attempts to prepare the stored procedure, an exception will be raised.

Syntax

property StoredProcName: string;

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

What do you think about this topic? Send feedback!