Working with Procedures
Go Up to Working with Stored Procedures
With isql, you can create, alter, and drop procedures and exceptions. Each of these operations is explained in the corresponding sections in this chapter.
There are two ways to create, alter, and drop procedures with isql:
- Interactively
- With an input file containing data definition statements
It is usually preferable to use data definition files, because they are easier to modify and provide separate documentation of the procedure. For simple changes to existing procedures or exceptions, the interactive interface can be convenient.
The user who creates a procedure is the owner of the procedure, and can grant the privilege to execute the procedure to other users, triggers, and stored
procedures.