Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> newbie q: compiling a package

newbie q: compiling a package

From: Vince Laurent <vlaurent_at_NOSPAM.networkusa.net>
Date: Tue, 15 Oct 2002 16:10:12 -0500
Message-ID: <rq0pqu8ki11r3mqd657scbgt7ihtdgjlcf@4ax.com>


We have a system which monitors oracle for invalid packages. One came up with the following one.

sapsnd:orasnd 27> ./orastat -iv
2002/10/15-16:06:07 orastat | oraver=8.1.7 oraver3=8.1 sqlcmd=sp 2002/10/15-16:06:07 orastat | ORACLE_SID=SND ORACLE_HOME=/oracle/SND/817_64
2002/10/15-16:06:07 orastat | Version=2.33 Host=sapsnd Company=ssmhc 2002/10/15-16:06:07 orastat | Invalid Objects

Object Name                                        Object Type
Status
-------------------------------------------------- --------------

SYSTEM.SPACER_ANALYZER                             PACKAGE BODY
INVALID       

2002/10/15-16:06:08 orastat | Found 1 Invalid Objects

I tried to recomplie it and got:

SVRMGR> alter PACKAGE SYSTEM.SPACER_ANALYZER compile BODY; MGR-00073: Warning: PACKAGE SYSTEM.SPACER_ANALYZER created with compilation errors.

And the package still reports that it INVALID.

So... many questrions.
What created this package? Is it something that came in the patch from 8.1.7.0 to 8.1.7.3? How can I look at it to recompile it with out getting errors? How do you look at ANY package? What is a package?

Thanks for your patience...
Vince Received on Tue Oct 15 2002 - 16:10:12 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US