Package and Package Body don't work!
Hallo,
I've build a package
CREATE OR REPLACE PACKAGE MySchema.MyPackage is
-- Subtypes
subtype TDescription is varchar2(50);
subtype X is ...;
subtype Y is ...;
-- Procedures
procedure MyProc_1(
atext IN TDescription);
procedure MyProc_2(
atext IN TDescription);
end;
CREATE OR REPLACE PACKAGE BODY MySchema.MyPackage is
procedure MyProc_1(
atext IN TDescription) is
begin
DELETE FROM MYTABLE1 WHERE DESCRIPTION = atext;
end;
procedure MyProc_2(
atext IN TDescription) is
begin
SELECT * FROM MYTABLE2 WHERE DESCRITPION LIKE atext;
end;
end;
If I only declare MyProc_1 (in Package and Body) all works. If I declare the two procs, the package is build without errors, the package body is build with compiling errors. When I look in Enterprise Manager Console at the package body and compile it, the error is in (Ln,Col): (1,1).
I don't have used double quotes in the schema objects. The tables and fields are there, exactly written like in the procs.
Any ideas?
Regards
Stephan Schneider