| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Help!
Doug
May be a case of the shared pool being either a) too small or b) too fragmented. Check for Ora-4031 errors in the trace files (it's a terrible thing when you can remember Oracle error numbers off the top of your head - maybe I need a new job!).
Hope this helps.
Pete
Doug Cowles wrote:
> Actually no. The way I got around this was to drop some other procudures that i
> don't
> need immediately. There were some errors in user_errors, but they had to do
> with
> a standard problem I have when importing procedure and packages because they
> don't consider a db_link valid. When this happens I compile manually after the
> import.
> In any case, after I dropped some other procedures, this same exact code goes in
> fine.
> I'm wondering..am I running out of room somewhere for compiled code?
>
> Peter Sharman wrote:
>
> > Doug
> >
> > Is the package owned by someone else? Try using select * from all_errors if
> > that's the case.
> >
> > Pete
> >
> > Doug Cowles wrote:
> >
> > > I'm trying to compile a package and it always says
> > > Warning! Package body compiled with compilation errors and won't run.
> > > But, if I do a show errors, or a show errors package body intfp2.exttest
> > >
> > > or even look at user_errors, I don't see anything.
> > > It just says no errors.
> > > I have no idea what is wrong, and this code has compiled successfully on
> > > many
> > > other schemas. Does anyone have any ideas?
> > >
> > > - Dc.
> >
> > --
> >
> > Regards
> >
> > Pete
> >
> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> > Peter Sharman Email: psharman_at_au.oracle.com
> > WISE Course Development Manager Phone: +1.650.607.0109 (int'l)
> > Worldwide Internal Services Education (650)607 0109 (local)
> > San Francisco
> >
> > "Controlling application developers is like herding cats."
> > Kevin Loney, ORACLE DBA Handbook
> > "Oh no it's not! It's much harder than that!"
> > Bruce Pihlamae, long term ORACLE DBA
> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
--
Regards
Pete
Peter Sharman Email: psharman_at_au.oracle.com WISE Course Development Manager Phone: +1.650.607.0109 (int'l) Worldwide Internal Services Education (650)607 0109 (local)San Francisco
"Controlling application developers is like herding cats."
Kevin Loney, ORACLE DBA Handbook
"Oh no it's not! It's much harder than that!"
Bruce Pihlamae, long term ORACLE DBA
 |
 |