update the package body in Oracle Database (Sql developer)

Viewed 21807

I need to have a miner update to the package body in Oracle Database using Oracle SQL Deverloper 3.2. The update does not need to change the package specification.

Using the Oracle SQL Deverloper, I right-click on the package name, choose "edit body", then update the body.

Then I find that it seems there are several ways to update the package body:

(1) click "run" button.

(2) click "compile" button.

(3) click "compile with debug" button.

(4) close the tab of package windows, then choose "yes" to save the changes on the pop-up windows.

My questions are:

1) what are the difference in the above 4 ways?

2) which is the proper way?

Thanks a lot

Regards

1 Answers
Related