SQL Developer does not compile package body
tx103108Apr 12 2013 — edited Apr 12 2013Linux OEL 6.3
Oracle 11gR2
-------------------
create or replace package my_package
as
....
end my_package;
/
create or replace package body my_package
as
....
end my_package;
/
Problem: Package body does not compile using SQL Developer 3.1. The error was that on the package body the name my_package does not match MY_PACKAGE. However, it does compile using any other tool.
Soln: To get the package body to compile, the following change was made -- see below (i.e. had to uppercase package body name):
create or replace package my_package
as
....
end my_package;
/
create or replace package body MY_PACKAGE
as
....
end MY_PACKAGE;
/
can anyone explain why this would be so?
Thanks.