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.