Create Reusable Procedure
Go Up to Creating and Editing SQL Procedures
Reusable procedures are maintained in the database and can save you time because they do not have to be recreated for every database application in which you want to use the procedure.
Reusable user-defined procedures are created in the Data Dictionary. For more information, see Reusing Procedural Logic