Manage Stored Procedures

Create, delete, or modify stored procedures.

Stored procedures are named collections of SQL statements and flow control statements. A stored procedure that performs a select, execute, or data modification command must have the same owner as the object acted upon.

A system administrator, a database owner, or a user or group with create procedure permission can create a stored procedure.

• Creating a Stored Procedure
  A stored procedure is a collection of SQL statements and optional control-of-flow statements stored under a name.
• Replacing a Stored Procedure Definition
  You can replace the SQL definition of a stored procedure and change whether the procedure is recompiled each time it is executed.
• Stored Procedure Properties
  Use the stored procedure Properties wizard to access and modify information on stored procedures.
• Granting Execute Permission on a Stored Procedure
  Grant execute permission on stored procedures.
• Revoking Execute Permission on a Stored Procedure
  Revoke execute permission on stored procedures.
• Deleting a Stored Procedure
  Use SAP Control Center to delete stored procedures.
• Generating DDL for a Stored Procedure
  Use SAP Control Center to generate a DDL script for stored procedures.