Re: [HELP]: Installing PL/SQL & Package support (more details)

From: Neil Greene <neil_at_bMD.com>
Date: Sun, 22 Jan 1995 21:26:00 GMT
Message-ID: <1995Jan22.212600.730_at_bMD.com>


In article <1995Jan22.052317.20748_at_bMD.com> Neil Greene <neil_at_bMD.com> writes:
> I am trying to hack away at one of our Oracle databases and I have come
 to
> a wall. I am running Oracle 7.1.3 under HP/UX 9.05. I manually ran the
> sqldba scripts to include pl/sql support, create the necessary views,
> catalogs, etc., etc., install help. Blah, blah, blah.
>
> I have noticed that things look a little weird when viewing the status
 of
> packages. There are several packages listed with the same name, one
> marked INVALID and one marked VALID. I also get "Warning: Package body
> compiled with compilation errors."
>
> I am assuming this may be become something may be failing on the
 database
> side with the installation. How can I correct this or validate my
> assumptions??

Here are some error messages from Oracle, found using "show errors".

I am receiving the following errors when compiling certain

LINE/COL ERROR

-------- -----------------------------------------------------------------
28/1     PLS-00103: Message 103 not found; No message file for
         product=SLAX, facility=PXMessage 119 not found; No message file
         for product=SLAX, facility=PXMessage 113 not found; No message
         file for product=SLAX, facility=PX

30/1     PLS-00103: Message 103 not found; No message file for
         product=SLAX, facility=PXMessage 104 not found; No message file
         for product=SLAX, facility=PXMessage 116 not found; No message
         file for product=SLAX, facility=PXMessage 118 not found; No
         message file for product=SLAX, fac


LINE/COL ERROR

-------- -----------------------------------------------------------------
35/6     PLS-00103: Message 103 not found; No message file for
         product=SLAX, facility=PXMessage 104 not found; No message file
         for product=SLAX, facility=PXMessage 116 not found; No message
         file for product=SLAX, facility=PXMessage 118 not found; No
         message file for product=SLAX, fac

38/11    PLS-00103: Message 103 not found; No message file for
         product=SLAX, facility=PXMessage 104 not found; No message file
         for product=SLAX, facility=PXMessage 116 not found; No message
         file for product=SLAX, facility=PXMessage 118 not found; No
         message file for product=SLAX, fac


--
Sincerely,

Neil Greene

---------------
benchMark Developments, Inc.
Received on Sun Jan 22 1995 - 22:26:00 CET

Original text of this message