<< Click to Display Table of Contents >> Current:  Create Data Set > SQL Data Set  Data Set for Stored Procedure

SQL Stored Procedure is a set of SQL statements for completing specific functions. They are stored to the database after being compiled. The user executes it by specifying the name of the stored procedure and giving the parameter (if there is any parameter in the stored procedure). Stored Procedure is an important object of the database. Any well-designed database application program should be used in the storage process.

 

To use Stored Procedure in Yonghong Z-Suite, you can apply directions (IN, OUT, and IN_OUT) to parameters in the "Edit Parameters" dialog. The direction of the parameter should be consistent with the database.