Re: [HELP]: Installing PL/SQL & Package support

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??
|>
|> ---
|> Sincerely,
|>
|> Neil Greene
|>
|> ---------------
|> benchMark Developments, Inc.
|> 11970 Charter Oak Parkway, St Louis MO 63146
|> Phone: 314-872-2907 / 800-872-3131
|> Email: Neil_at_bMD.com [NeXT/Mime mail accepted]

Nothing is probably wrong with your installation. If a package contains compilation errors, then it is created with a status of invalid. If you have two entries with the same package name, they are probably owned by different users. To see the errors, query user_errors or all_errors or dba_errors. Received on Wed Jan 25 1995 - 20:55:25 CET