Introduction to Procedures

This section discusses the available procedures and their functions.

• Creating Procedures
  Procedures are created using the CREATE PROCEDURE statement. You must have RESOURCE authority to create a procedure.
• Altering Procedures
  You can modify an existing procedure using either Sybase Central or Interactive SQL. You must have DBA authority or be the owner of the procedure.
• Calling Procedures
  CALL statements invoke procedures. Procedures can be called by an application program or by other procedures.
• Copying Procedures in Sybase Central
  You can copy procedure codes from one database to another connected database.
• Deleting Procedures
  Once you create a procedure, it remains in the database until someone explicitly removes it. Only the owner of the procedure or a user with DBA authority can drop the procedure from the database.
• Permissions to Execute Procedures
  A procedure is owned by the user who created it and that user can execute it without permission.
• Returning Procedure Results in Parameters
  Procedures return results to the calling environment.
• Returning Procedure Results in Result Sets
  In addition to returning results to the calling environment in individual parameters, procedures can return information in result sets. A result set is typically the result of a query.