Developers working with SQL databases often prefer to use Stored Procedures rather than direct SQL statements in their applications for better performance and enhanced security.
The following topics introduce you to the DataLayer.SP element, which provides the capability of running stored procedures on SQL database servers:
- DataLayer.SP Attributes
- Retrieving Data with DataLayer.SP
- Stored Procedure Parameters
- Writing Data to the Database
- Using Studio's DataLayer Wizard
Stored procedures executed using this element must return a rowset. Ensure that they end with a SELECT statement.
Using Oracle? Connection strings to Oracle databases must include the statement "PLSQLRSet=1" in order to use stored procedures.