Procedures Editor (Oracle)

From DBArtisan
Jump to: navigation, search

Go Up to Oracle Object Editors

The Procedures Editor lets you view and modify the SQL code and properties of a procedure.

To edit a procedure

  1. Open an editor on the procedure. For details, see Opening an Object Editor.
  2. Use the following table as a guide to understanding and modifying the settings on the tabs of this editor:
Tab Settings and tasks

Properties

Lets you work with properties in the following categories:

Properties

Lets you view Status, and Last Modified properties.

Size Information

Lets you view Source Size, Parsed Size, Code Size, and Error Size

Definition

Lets you modify the SQL code for a procedure.

Dependencies

For details on using this tab, see Working with Object Dependencies.

Permissions

For details on using this tab, see Working with Privileges and Permissions.

3. When finished, you can submit your changes. For details, see Previewing and Submitting Object Editor Changes.