Procedures Wizard (Oracle)
Go Up to Oracle Object Wizards
Procedures are a reusable block of PL/SQL, stored in the database, that applications can call. Procedures streamline code development, debugging, and maintenance by being reusable. Procedures enhance database security by letting you write procedures granting users execution privileges to tables rather than letting them access tables directly. Procedures do not return values, unlike functions.
- Note: To create a procedure in your own schema, you need CREATE PROCEDURE privileges. To create a procedure in someone else's schema, you need CREATE ANY PROCEDURE privileges.
To create a new procedure using a wizard:
- Open a creation wizard for a procedure. For details, see Opening an Object Wizard.
- Use the following topics as a guide to setting properties and performing tasks as you pass through the wizard panels:
- Properties panel - Procedures (Oracle) - Properties.
- Definition panel - for details, see Procedures (Oracle) - Definition.
- Finally, use the Execute button to create the object.
Procedures (Oracle) - Properties
When creating or editing a procedure, this tab/panel lets you work with the following settings:
| Setting | Description |
|---|---|
|
Owner |
Select the owner of the procedure. |
|
Name |
Provide a name for the procedure |
Procedures (Oracle) - Definition
Complete the CREATE PROCEDURE outline provided by typing or pasting the body of the procedure.