Create a stored procedure

The process to create a stored procedure is straightforward; typically, the time-consuming work is in the design of the stored procedure, and the debugging and testing of the procedure.

This section describes the following key steps for creating a stored procedure:
  • Design a stored procedure
  • Create a stored procedure