Stored Procedure Overview

A stored procedure is a precompiled executable object that contains one or more SQL statements. Using stored procedures provides several advantages including: higher performance, reduced network traffic, and improved security.

The Table Data Gateway template allows you to control whether the generated code will be using stored procedures or dynamic SQL to access MS SQL Server, MSDE, Oracle, and Sybase ASE databases. To activate the generation of stored procedures, select the database node in the RapTier project tree and check the Generate Stored Procedures checkbox.

After the source code is generated, go to the <OutputDirectoryPath>\Db\Sql directory to find the stored procedure code. To add the stored procedures to your database perform the following steps:

MS SQL Server

• Open SQL Query Analyzer.
• On the File menu, choose the Open menu item.
• Open the "<YourProjectRootDirectory>\Db\Sql\<DatabaseCodeName>_MSSQL.sql" file.
• On the Query menu, choose the Execute menu item.

Oracle

• Open SQL*Plus Worksheet.
• On the Worksheet menu, choose the Run Local Script… menu item.
• Open the "<YourProjectRootDirectory>\Db\Sql\<DatabaseCodeName>_PackageDeclaration_Oracle.sql" file.
• On the Worksheet menu, choose the Run Local Script… menu item.
• Open the "<YourProjectRootDirectory>\Db\Sql\<DatabaseCodeName>_PackageBody_Oracle.sql" file.