Disabling PL/SQL Program Unit Editing

Previous

Next

By default, developers can change and compile PL/SQL source code when browsing database procedures, packages, and functions in Object Browser. As an Oracle Application Express administrator, you can control PL/SQL program unit editing for an entire workspace by making a selection from Allow PL/SQL Program Unit Editing.

To disable PL/SQL program unit editing:

1. Log in to Oracle Application Express Administration Services. See "Logging in to Oracle Application Express Administration Services".

2. Click Manage Service.

3. Click Manage Environment Settings.

4. Under Application Development, select No for Allow PL/SQL Program Unit Editing.

5. Click Apply Changes.