The command create or replace PACKAGE ... is not being honored.

by Philip Gardocki
(Pennsylvania)

The command create or replace PACKAGE ... is not being honored.


I have had numerous times where if I use @ command in a driver file on a Package Body or Spec, where the old version of the code remains intact. The new version doesn't get uploaded. This has even happened when I drop the package in question, and use @THIS_PACKAGE_SPEC.SQL. The old package will come back. The error logs show the package loaded and compiled normally.

One way to deal with this is to load the THIS_PACKAGE_SPEC.SQL into developer and execute it by itself.

Another is to drop the old package, shut down and restart Oracle SQL Developer then proceed normally.

This problem has exhibited itself using both Oracle SQL Developer, and SQLPlus. In Unix and Linux environments.

Anyone else experience this?

Click here to post comments

Join in and write your own page! It's easy to do. How? Simply click here to return to Oracle Questions.