Re: newbie q: compiling a package

"Vince Laurent" <vlaurent_at_NOSPAM.networkusa.net> wrote in message news:rq0pqu8ki11r3mqd657scbgt7ihtdgjlcf_at_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

1 some moron, who was trespassing
2 definitely not
3 you need to issue the
show errors
command in sql*plus, or the select * from user_errors. The first you can use directly after a compilation, but the errors will remain 4 ever in dba_|all_|user_errors
to view the code:
select text
from user_source
where name = 'SPACE_ANALYZER'
order by line

A package is a collection of procedures,functions, types, constants, variables with a private and a public part. The procedures etc in the public part can be called by any anonymous block or procedure/function. The pl/sql reference manual is your friend.

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address