Editing Packages

Previous

Next

To edit packages and package bodies, you can use the Object Browser page, the SQL Commands page, or the SQL CREATE OR REPLACE statement with SQL Command Line.

If you use the SQL CREATE OR REPLACE statement with SQL Command Line, you simply type in the modified package specification or body code. See "Entering and Executing SQL Statements and Commands".

To edit a package in the SQL Commands page:

1. Log in to the Database Home Page. See "Logging in to the Database Home Page".

2. On the home page, click the SQL icon to display the SQL page.

3. Click the SQL Commands icon to display the SQL Commands page.

4. Click the Saved SQL tab to display the saved SQL modules.

5. Click the name of the saved SQL that contains the package code that you want to edit.

6. Modify the source code for the package. Click the Run button if you want to execute the package.

7. When you are finished, you can click the Save button to save the code for future use.

To edit a package with the Object Browse page:

1. Log in to the Database Home Page. See "Logging in to the Database Home Page". To run the examples in this guide, log in as user HR with your password for the HR account.

2. On the Database Home Page, click the Object Browser icon.

3. In the object list, select Packages and then click the package you want to display.

   The package specification information displays.

4. With the package specification displayed, click the Edit button to modify the package specification. You can click the Body tab to edit the source code for the package body if it exists.

5. Click the Compile button to ensure your changes did raise any errors when executed. Compiling the package also saves the changes.