Set StoredProcName to specify the name of the stored procedure to call on the server. If StoredProcName does not match the name of an existing stored procedure on the server, an exception is raised. 

When you set the StoredProcName property, TSQLStoredProc queries the database server to ascertain the parameters of the specified stored procedure. It uses this information to initialize the Params property. You can subsequently use the Params property to adjust the properties of any parameters and supply values for the parameters. Some servers do not supply information about stored procedure parameters. In those cases, you must explicitly add the parameters. 

Params 

PackageName 

Representing the Results of a Stored Procedure 

Specifying the Command to Execute 

Executing the Commands using TSQLDataSet 

Specifying the Data to Display using TSQLDataSet 

Using TSQLStoredProc