Re: Strange problem - need to recompile a valid proc

Hi,

does it occur every time you start ASP? Have you tried start same ASP twice?

It can be that some other object, which is dependency for your procedure, has not been imported at the moment of the procedure import.

HTH,
Mario.

"Alan" <alan_at_erols.com> wrote in message news:2u4ot0F253ie4U1_at_uni-berlin.de...
>
> "tangman" <discusboy_at_gmail.com> wrote in message
> news:b382f4aa.0410250822.43eac527_at_posting.google.com...
> > Hi. Hope one of you can help. I am currently running 9i and do a
> > nightly export of one database schema to another exactly configured
> > db. When I acess one of the proc. in the target db using ASP, I would
> > get an error msg ora-06550 . I traced the proc and it show as valid.
> > To fix the problem, I would need to recompile that proc and just that
> > one proc. Anyone knows where is the problem? Thanks.
>
> The 06550 by itself is useless to help solve the problem. What is the rest
> of the error message? What is the code? I am guessing that the asp code
user
> that is running the procedure in question does not have direct rights to
an
> underlying object, and when you recompile it, you are recompiling it and
> running it as the owner of the object, or at least as someone who has
> direct rights, but that's a wild guess, being as there is not enough
> information provided.
>
>
Received on Mon Oct 25 2004 - 14:32:31 CDT