Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Package and Package Body don't work!

294348Aug 13 2002
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 10 2002
Added on Aug 13 2002
3 comments
472 views