Re: Unable to Create Package Body

From: Ivan Samuelson <bolski_at_indy.net>
Date: 1996/07/10
Message-ID: <4s0itj$pbk_at_news.indy.net>#1/1

Michael Gabriel (GabrieM_at_water4.wcbe.edu.on.ca) wrote:
: CREATE OR REPLACE PACKAGE susp_package IS

                         ^^^^^^^^^^^^

: END susp_package;

[rest of package spec deleted]

: CREATE OR REPLACE PACKAGE BODY susp_package_body IS

                                 ^^^^^^^^^^^^^^^^^

[rest of package body deleted]

: END susp_package_body;
: /

Your problem is that for the package specification, you state the name of the package is susp_package. Then, you turn around in the body specification and say that the package is susp_package_body. Oracle can't find a package specification with that name. When you create a package, you MUST use the same name for the package specification and the package body specifiation.

Therefore, I'd say in the CREATE OR REPLACE PACKAGE BODY, just use susp_package.

Hope this helps.

--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Ivan Samuelson, Consultant   *   Blue Ribbon Campaign Supporter
Profound Consulting          *   bolski_at_indy.net
http://indy.net/~profound    *   http://chaos.taylored.com/home/bolski/
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

Received on Wed Jul 10 1996 - 00:00:00 CEST